SELECT a.* FROM Table1 a INNER JOIN Table2 b ON a.ID = b.ID
SELECT a.* FROM Table1 a left JOIN Table2 b ON a.ID = b.ID where b.id is null
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)