join query

From: Krishan Gupta <krishan.gupta_at_etcc.com>
Date: Tue, 20 Jan 2009 11:28:50 -0600
Message-ID: <C0D6C26683355D43B6F85842E5DE9E9152D7C1_at_etccex03.etcc.local>



Hi all..,  

This may be very simple but I guess I need experts help for the following in oracle 10g database :-  

select * from xx_case;  

pos_id case_id

2                C1

2                C2

 

 

select * from xx_box;  

pos_id box_id

2                B1

2                B2

 

The only common column between these two tables is pos_id.  

How do I write query from these two tables so that the output result would be  

pos_id case_id box_id

2               C1                  B1

2               C2                  B2

2                                     B3

2                                     B3

 

 

Thanks and Regards

Krishan  

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 20 2009 - 11:28:50 CST

Original text of this message