Accessing Multiple Tables › Additional Search Criteria in a Join
Remember that you specify the columns to be joined in the WHERE clause. You can have additional search criteria in the WHERE clause as well by using AND and OR.