Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jambu Krishnamurthy A Refresher on Joins RE: A Refresher on Joins
John Bonano
Grasshopper
Points: 21
More actions
April 24, 2007 at 4:12 pm
#702279
Dennis, to get the result set you need, you can do the following:
select a.f1, b.f1, c.f1
from t1 a
full join t2 b on a.f1 = b.f1
full join t3 c on c.f1 = ISNULL(b.f1, a.f1)
John