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

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

瀏覽:618
日期:2025-05-11
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 ......看更多