Help with a simple query please

[chudson007@hotmail.com]

I have Two Tables, TableA and TableB, both containing a common field,
Feild1.

How do I find all records in TableA, where Field1 is not in TableB?


Regards,
Ciarán

[David Portas]

Re: Help with a simple query please

SELECT A.*
FROM TableA AS A
LEFT JOIN TableB AS B
ON A.col1 = B.col1
WHERE B.col1 IS NULL

--
David Portas
SQL Server MVP
--

[Ryan]

Re: Help with a simple query please

Try

SELECT
A.*

FROM
TableA A
LEFT JOIN TableB B ON
A.Field1 = B.Field1

[Ryan]

Re: Help with a simple query please

Sorry, didn't read it properly. David's answer is correct.