Home Forums SQL Server 2008 T-SQL (SS2K8) Annoying join problem & frozen brain. RE: Annoying join problem & frozen brain.
laurie-789651
SSCertifiable
Points: 7680
More actions
August 21, 2012 at 4:30 am
#1528025
In fact you don't need the WHERE clause:
SELECT D.a, A.a, A.b
FROM D
LEFT OUTER JOIN A
ON A.a = D.a And A.b=1
...but you've fixed it. Anyway - there are a few ideas there...