HI,

I have a query in which in where clause I have used not in clause. Now I want to use join instead of it. Can I do it? If yes how?


Dharm

__________________
Dharmendra
Software Engineer

Can you post a sample of your code

Jaime E. Maccou

You can use a LEFT JOIN for this purpose. As an example, to convert the following NOT IN syntax:

SELECT * FROM TableA
WHERE ID NOT IN (SELECT ID FROM TableB)

You can do it this way using a LEFT JOIN:

SELECT *
FROM TableA A LEFT OUTER JOIN TableB B
ON A.ID = B.ID
WHERE B.ID IS NULL

You may also refer to Question #3 in the following link:

Frequently Asked Questions - SELECT Statement
http://www.sql-server-helper.com/faq/select-p01.aspx

SQL Server Helper
http://www.sql-server-helper.com