Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

That expression closely resembles the expression I used in the WHERE clause in the first example. Since there are two ways to accomplish the same kind of query, which should you use?