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-2 b ON A.Eid = b.cid AND a.DocNo=b.CDocNo
WHERE
Eid IN (SELECT Cid FROM @b-2)
ORDER BY
a.Eid
That seems to do the trick, unless i've mis-understood what you're after.
Thanks,
Simon