SELECT T1.*
  FROM TABLE1 AS T1
 WHERE NOT EXISTS(SELECT *
                    FROM TABLE2 AS T2
                   WHERE T2.ID_Table1 = T1.ID)

quote:

---

Originally posted by Lamprey

Another alternative is to use a LEFT OUTER JOIN.

---

quote:

---

Originally posted by Kristen

quote:

---

Originally posted by Lamprey

Another alternative is to use a LEFT OUTER JOIN.

---

That's usually (99%!!) my preferred solution, but I always hesitate to recommend it as I think it may be perceived of as "esoteric" - what do you think? (I expect it may be undesirable too if the Second Table has multiple hits for the JOIN criteria)

---

-- Source record removed
DELETE D
FROM MyTable AS D
    LEFT OUTER JOIN OtherTable AS S
        ON S.ID = D.ID
WHERE S.ID IS NULL

-- Source record changed
UPDATE D
SET Col1 = S.Col1
FROM MyTable AS D
    JOIN OtherTable AS S
        ON S.ID = D.ID
WHERE S.Col1 <> D.Col1

-- New record added to Source
INSERT MyTable(Col1, Col2, ...)
SELECT Col1, Col2, ...
FROM OtherTable AS S
    LEFT OUTER JOIN MyTable AS D
        ON D.ID = S.ID
WHERE D.ID IS NULL