Query problem

[Poppy]

I have 2 tables, each which contain usernames and id's.

I need to extract all users from tableA which do not appear in tableB but
cant figure out the syntax of the query.

Any Ideas ?

Thanks in advance

 

[Marshall Barton]

I have 2 tables, each which contain usernames and id's.

I need to extract all users from tableA which do not appear in tableB but
cant figure out the syntax of the query.

SELECT tableA.*
FROM tableA LEFT JOIN tableB
ON tableA.user = tableB.user
WHERE tableB.user Is Null