by using an INNER JOIN, you will display all records that are in both tables.

by using a LEFT JOIN, you will see all records in table1 and a corresponding matching record from table2 if there is one, otherwise you will get a null for the table2 fields. (which is what I specified as a condition, so we get the ones that DO NOT have a match in the second table)

the use of the LEFT JOIN will give lychew what he needs to get done, inner join will not help him here.

lychew wants the records that DO NOT have a match in table2. If he wanted a match, INNER JOIN is the winner.