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)