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..,
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-lReceived on Tue Jan 20 2009 - 11:28:50 CST