What's a multi-table select, really?
JOIN
tie two tables together based on a column
INNER, OUTER, LEFT, RIGHT
UP DOWN ALL-AROUND
NEXT
INDEX
Master Index