Posted by: STUPIDA January 15, 2014
Login in to Rate this Post:
0 
? 
?
mvc,
That's not the proper way to do it. I know it works. But SQL query is not optimized in that Sub-query...............
Here it is
Select [Column lists...............]
FROM table1 a
LEFT JOIN table2 b
ON a.SameColumnName = b.SameColumnName
WHERE b.SameColumnName IS NULL
That's not the proper way to do it. I know it works. But SQL query is not optimized in that Sub-query...............
Here it is
Select [Column lists...............]
FROM table1 a
LEFT JOIN table2 b
ON a.SameColumnName = b.SameColumnName
WHERE b.SameColumnName IS NULL