About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Tuesday, 21 January 2014

How to select rows with no matching entry in another table?

SELECT t1.ID
FROM Table1 t1
    LEFT JOIN Table2 t2 ON t1.ID = t2.ID
WHERE t2.ID IS NULL





www.varuntechnologies.in

No comments:

Post a Comment