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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-04 : 08:49:24
|
Kristin writes "I have been told that "not in" is a inefficiently implemented SQL command. This being the case, what are alternatives to using "not in"? Is the the only way to find intersection in SQL?
This is the query that I am trying to implement.
SELECT descriptions
FROM tableOne
where descriptions not in
(SELECT descriptions
FROM tableTwo)
Thanks for your help,
Kristin
SQL Server 7.0" |
|
|
|
|
|
Alternatives to Using NOT IN