Home Forums SQL Server 2008 T-SQL (SS2K8) Differnet Join Statement RE: Differnet Join Statement
s_osborne2
SSCertifiable
Points: 6726
More actions
May 9, 2013 at 4:41 am
#1613700
SELECT
a.Eid,
b.cDocNo
FROM
@A a
LEFT OUTER JOIN @B b ON A.Eid = b.cid AND a.DocNo=b.CDocNo
WHERE
Eid IN (SELECT Cid FROM @B)
ORDER BY
a.Eid
That seems to do the trick, unless i've mis-understood what you're after.
Thanks,
Simon