Left Join Question

[theunknownknight]

I am using Access 2000
I am doing a left join between 2 tables.
I know that it will return everything on the left as well as everything that it matches with on the right.

HOWEVER, I want to do a left join that returns everything on the left BUT leave out all the records that match with the right.

How would I do this?

 

[swampBoogie]

select * from t left outer join q on tpk = qpk
where qpk is null