Home Forums SQL Server 2008 SQL Server 2008 - General Combining two databases DB1 & DB2 tables Sql query to one Sql Query RE: Combining two databases DB1 & DB2 tables Sql query to one Sql Query

  • December 18, 2014 at 5:06 am

    #1765413

    Change the table reference in DB1 to DB1.dbo.ITEM

    Change the table reference in DB2 to DB2.dbo.ITEM

    and add UNION ALL between the two

    Far away is close at hand in the images of elsewhere.
    Anon.