Home Forums SQL Server 2008 SQL Server Newbies What would the SQL2008 equivilent be to outer union corr? RE: What would the SQL2008 equivilent be to outer union corr?

  • March 15, 2012 at 8:46 am

    #1459912

    kinderdesign (3/15/2012)

    Thanks Gianluca, but it seems as though this would be pretty complex.

    Not complex at all.

    5 tables? No problem: just add them inside the IN predicates:

    ... object_id IN (

    OBJECT_ID('TableA'),

    OBJECT_ID('TableB'),

    OBJECT_ID('TableC'),

    OBJECT_ID('TableD'),

    OBJECT_ID('TableE')

    )

    Obviously, the choice is yours.

    -- Gianluca Sartori