Posted by Erland Sommarskog on 10/02/92 11:51

SQL Menace (denis.gobo@gmail.com) writes:
> or use NOT EXISTS
>
> SELECT * FROM tableA A WHERE NOT EXISTS (SELECT * FROM
> tableB WHERE client_id = A.client_id )

Yes, this is the preferred syntax for the given problem, as it clearly
expresses what it's all about.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]