Post reply

query to combine data from 2 tables into 1 view

  • September 15, 2005 at 7:39 am

    #91295

    i have an archive table and current table, both with same columns.

    for reporting purposes i'd like a query to combine data from both tables. SELECT INTO will work but it produces a new table which seems unnecessary. is there a way to create a view of the combined data?

    thanks for any help

  • September 15, 2005 at 7:48 am

    #590136

    Select col1, col2 from dbo.archive

    union all

    select col1, col2 from dbo.MainTable

  • September 15, 2005 at 8:02 am

    #590144

    SELECT Column1, Column2 FROM OldTable

    UNION ALL

    SELECT Column1, Column2 FROM NewTable

  • September 15, 2005 at 8:02 am

    #590143

    Bugger, sorry about that, didn't notice the reply above

  • September 15, 2005 at 8:15 am

    #590155

    Don't be... happens more often than you think . Thanx for helping.

  • September 15, 2005 at 8:31 am

    #590163

    that's exactly what i was looking for - thanks very much

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply