SQL SERVER – Introduction to JOINs – Basic of JOINs | Journey to SQL Authority with Pinal Dave

Hi Pinal, I have a question concerning a statement you made above where rather than writing a query as SELECT t1.* FROM Table1 t1 WHERE t1.ID NOT IN (SELECT t2.ID FROM Table2 t2) I should write it as SELECT t1.*,t2.* FROM Table1 t1 LEFT JOIN Table2 ...

blog.sqlauthority.com