Home Forums SQL Server 2008 T-SQL (SS2K8) Differnet Join Statement RE: Differnet Join Statement

  • 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


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