select records...

Question

Hi, I have two tables with same column names. I need to select those records of table 1 which are not in table 2.

Tapan Patel · Answer

If you are saying that you need to select the records for the column which are only present in table 1, then take a look at below link.. https://msdn.microsoft.com/en-us/library/ms188055.aspx Please mark it as an answer if it resolves the issue.

snowal raj · Answer

it have 2 types 1.Using Not in SELECT * FROM Table1 WHERE ID NOT IN (SELECT ID FROM Table2) but its not get all records in all time 2.Using Join SELECT A.ID FROM TABLE1 A LEFT JOIN TABLE2 B ON A.ID=B.ID WHERE A.ID IS NULL Its Give Perfect result in any time

Manas Mohapatra · Answer

You can use NOTIN or EXCEPT or LeftJoin to achieve the result. --Using NotIn select * from table1 where productid NOT IN ( select * from table2) --USE EXCEPT select * from table1 except select * from table2 Difference between Except and NotIn is: Except return distinct records but NotIn doesn't. http://dba.stackexchange.com/questions/83684/except-operator-vs-not-in

Bikesh Srivastava · Answer

Hi Amit, I have already done this logic you can use query like this. SELECT * FROM Table2A WHERE NOT EXISTS ( SELECT * FROM Table1B WHERE A.[Company]=B.[Company/Account] ); Mark as answer if find exact answer.

Ananth G · Answer

SELECT a.id FROM Table1 a LEFT JOIN Table2 b ON a. id =b. id WHERE a.id IS NULL it help to you

Vinay Singh · Answer

Have a look of the query SELECT * FROM Table1 WHERE ID NOT IN ( SELECT ID FROM Table2 )

Jisny Av · Answer

You can use EXCEPT clause. Please go through below link http://www.tutorialspoint.com/sql/sql-except-clause.htm

Praveen Sreeram · Answer

SELECT t1.name FROM table1 t1 LEFT JOIN table2 t2 ON t2.name = t1.name WHERE t2.name IS NULL Hope it helps, Thanks, Prawin

select records...

Answers (8)