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,
SaiOne 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.
No comments:
Post a Comment