• 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



    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne