Home Forums SQL Server 2008 SQL Server Newbies Merging Data from two source into one destination table RE: Merging Data from two source into one destination table

  • October 6, 2015 at 3:22 pm

    #1831870

    If the table structure matches you can use UNION which will remove duplicates also .

    select * from table1

    UNION

    select * from table2