Outer Joins
An outer join does not require each record in the two joined tables to have a matching record. The joined table retains each record—even if no other matching record exists. Outer joins subdivide further into left outer joins, right outer joins, and full outer joins, depending on which table's rows are retained (left, right, or both).
(In this case left and right refer to the two sides of the JOIN keyword.)
No implicit join-notation for outer joins exists in standard SQL.
Read more about this topic: Join (SQL)
Famous quotes containing the words outer and/or joins:
“Self-alienation is the source of all degradation as well as, on the contrary, the basis of all true elevation. The first step will be a look inward, an isolating contemplation of our self. Whoever remains standing here proceeds only halfway. The second step must be an active look outward, an autonomous, determined observation of the outer world.”
—Novalis [Friedrich Von Hardenberg] (1772–1801)
“The Peer now spreads the glitt’ring Forfex wide,
T’inclose the Lock; now joins it, to divide.”
—Alexander Pope (1688–1744)