Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Other Approaches to NOT EXISTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-21 : 10:37:01
Alex writes "Hello, I have 2 tables with same format, tableA and tableB. I would like to select all those rows that are only in tableA but not tableB. Is there any way to do this other than using "where not exists ... "? I think the NOT EXISTS clause make my query very slow..."

Article Link.

   

- Advertisement -