Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    23

    Unanswered: How to append records of one table to another?

    Hi I have a table with the following structure:

    Table1
    -------
    Dept
    Filed1
    Filed2
    Field3
    Field4
    Field5

    I have another table with the following structure
    (Basically this table will contain a subset of coloumns of Table1)

    Table2
    -------
    Dept
    Field1
    Field2

    Now using a query I would like see all the records with all coloumns in Table1 plus all the records in Table2 appended

    i.e
    if Table1 row is

    IT F1 F2 F3 F4 F5

    and if Table2 row is

    IT F11 F22
    Sales F12 F23

    I would like to see a result set with the following structure

    Resultset

    IT F1 F2 F3 F4 F5
    IT F11 F22 NULL NULL NULL
    Sales F12 F23 NULL NULL NULL

    Can some body explain me how to do this with a query. I tried using union but it requires identical coloumns on both ends( Ofcourse, we can acheive this by having Field3,Field4 and Field5 as blank columns in Table 2 but I don't wanna do that as my original tables are too huge to handle this).

    Any input is appreciated.

    Thanks,
    Sai

  2. #2
    Join Date
    May 2004
    Posts
    125
    One ugly way to do it is:

    select column1, column2, column3, column4, column5, column6 from table1
    union
    select column1, column2, column3, null, null, null from table2

    Pain in the butt to do if you have a lot of columns but it will get you the rs back that you want.


    Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •