Equality Joins

From rbachwiki
Revision as of 18:59, 22 October 2017 by Bacchas (talk | contribs)
Jump to navigation Jump to search

The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. These joins are called equality joins but are also referred to as equijoins, inner joins, or simple joins.

SELECT b.title, b.pubid, p.name
FROM books b, publisher p
WHERE b.pubid = p.pubid
AND (b.cost < 15 OR p.pubid = 1)
ORDER BY title;
SELECT c.lastname, c.firstname, b.title
FROM customers c, orders o, orderitems oi, books b
WHERE c.customer# = o.customer#
 AND o.order# = oi.order#
 AND oi.isbn = b.isbn
ORDER BY lastname, firstname;
SELECT c.lastname, c.firstname, b.title, b.category
FROM customers c, orders o, orderitems oi, books b
WHERE c.customer# = o.customer#
 AND o.order# = oi.order#
 AND oi.isbn = b.isbn
 AND category = 'COMPUTER'
ORDER BY lastname, firstname;