"exclude" joining

[Niels van de Coevering]

I was wondering if anyone knows how to do the following:

I have two tables (A and B) with shared id's. I want to create a query using a join selecting all records from table A excluding the records with id's that are present in table B.

I know I can do this like: SELECT * FROM A WHERE A.id NOT IN (SELECT B.id FROM B),
but it would be more fancy to do it with a join statement.

Thanks