How to combine 12 tables with some different and some same fields
- by Deven
Hi friends i am having problem in joining tables in oracle my tables are shown bellow
table1 looks like
id Name Jan
7001 Deven 22
7002 Clause 55
7004 Monish 11
7010 Dipesh 55
7070 Dipika 100
table2 looks like
id Name Feb
7001 Deven 12
7002 Clause 15
7003 Nimesh 20
7004 Monish 21
7005 Ritesh 22
table 3 looks like
id Name Mar
7001 Deven 122
7020 Chalse 155
7003 Nimesh 88
7033 Monica 217
7070 Dipika 180
like this i am having 12 tables from january to December hwo can i combine this and get out put like bellow
table2 looks like
id Name Jan Feb Mar ...................... Dec
7001 Deven 22 12 122
7002 Clause 55 15 - .......................-
7003 Nimesh - 20 88 .......................2
7004 Monish 11 21 - .......................-
7005 Ritesh - 22 - .......................20
7010 Dipesh 55 - - .......................-
7020 Chalse - - 155 .......................-
7033 Monica - - 217 .......................100
7070 Dipika 100 - - .......................-
