I've heard, you need something better. Try this:

select table1.* from table1 left join table2 on table1.PrimaryKey = table2.ForeignKey having isnull(table2.ForeignKey)

Alexander