[<<][sql][>>][..]
Sat Jul 7 10:14:10 EDT 2012

Joins

Inner joins:  filtered carthesian product
------------------------------------------
INNER JOIN:   subset of carthesian product that matches predicate
JOIN:         like INNER JOIN but only equality predicates (equi join)
NATURAL JOIN: (equi) JOIN with automatic column name matching
CROSS JOIN:   unrestricted carthesian product


Outer joins:  filtered product + all non-matching rows
------------------------------------------------------
LEFT  OUTER JOIN
RIGHT OUTER JOIN


[1] http://en.wikipedia.org/wiki/Join_(SQL)



[Reply][About]
[<<][sql][>>][..]