JOIN SQL — это просто!

 

Таблица с книгами

Таблица с магазинами 

INNER JOIN

SELECT books.id, books.title, shops.nameshop
FROM books
INNER JOIN shops
ON books.id = shops.book_id;

 

LEFT JOIN

SELECT books.id, books.title, shops.nameshop
FROM books
LEFT JOIN shops
ON books.id = shops.book_id;

 

RIGHT JOIN

SELECT books.id, books.title, shops.nameshop
FROM books
RIGHT JOIN shops
ON books.id = shops.book_id;

 

FULL OUTER JOIN

SELECT books.id, books.title, shops.nameshop
FROM books
LEFT JOIN shops
ON books.id = shops.book_id
UNION
SELECT books.id, books.title, shops.nameshop
FROM books
RIGHT JOIN shops
ON books.id = shops.book_id;

 

 

Понравилась статья? Поделиться с друзьями: