joining table of oracle

Posted by Deven on Stack Overflow See other posts from Stack Overflow or by Deven
Published on 2010-05-31T08:28:52Z Indexed on 2010/05/31 8:32 UTC
Read the original article Hit count: 307

Filed under:
|

Hi friends i am having problem in joining two tables in oracle my two tables are shown bellow

table1 looks like

id        Name      Jan
7001    Deven    22
7002    Clause    55
7004    Monish    11

table2 looks like

id        Name      Feb
7001    Deven    12
7002    Clause    15
7003    Nimesh    20
7004    Monish    21
7005    Ritesh    22

i want to combine this two table and want answer like bellow

table2 looks like

id        Name      Jan    Feb
7001    Deven    22     12
7002    Clause   55     15
7003    Nimesh    -       20
7004    Monish   11     21
7005    Ritesh    -        22

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about table