joins
A
http://en.wikipedia.org/wiki/Join_(SQL)
JOIN
is a means for combining fields from two tables by using values common to each. ANSI-standard SQL specifies four types of JOIN
: INNER
, OUTER
, LEFT
, and RIGHT
. http://en.wikipedia.org/wiki/Join_(SQL)