Help with a simple query please

#1 (**permalink**) 02-29-2008, 08:51 AM

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

#2 (**permalink**) 02-29-2008, 08:51 AM

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
--

#3 (**permalink**) 02-29-2008, 08:51 AM

Try

SELECT
A.*

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

#4 (**permalink**) 02-29-2008, 08:51 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode