Exclude values that appear in a certain table

[DB2010MN26]

I have two tables I'm quering from. I want to exclude a certain value that appears in one table, while including it if it appears in another. Essentially if the value appears in both tables, I do not want it included, how would I accomplish this?

[weekend00]

exclude: table1
including: table2

select table2.* from table2 left join table1 on table1.key=table2.key where table1.key is null

[DB2010MN26]

I'm sorry but I don't understand. I joined the two tables but all that seams to do is show the records that exist on both. I want to do the opposite.

[weekend00]

select table2.* from table2 left join table1 on table1.key=table2.key where table1.key is null

will show records in table2 but not in table1.

[DB2010MN26]

Got it working, Thanks!

On a side note, is it just me or is the join properties box in access mis-leading when it describes option 2 (left join).