While there are other types of JOINs supported by various flavors of SQL, most implementations of SQL support the INNER JOIN, LEFT JOIN, and RIGHT JOIN constructs.

2) Depending on the size of the tables, the different query plans could have drastically different run times. if the first issue I mentioned isn't really an issue, run an explain on each query to ...