Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jambu Krishnamurthy A Refresher on Joins RE: A Refresher on Joins
Bojidar Alexandrov
Old Hand
Points: 396
More actions
April 24, 2007 at 1:27 am
#702077
Better way is:
SELECT *
FROM t1 a
LEFT JOIN t2 b ON a.f1=b.f1
WHERE b.f1 IS NULL