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:
“Once conform, once do what other people do because they do it, and a lethargy steals over all the finer nerves and faculties of the soul. She becomes all outer show and inward emptiness; dull, callous, and indifferent.”
—Virginia Woolf (1882–1941)
“One joins the movement in a valueless world,
Choosing it, till both hurler and the hurled,
One moves as well, always toward, toward.”
—Thom Gunn (b. 1929)