Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL question
Hi all,
I have three table like below which I want to join somehow, is this possible?
Table A Table B Table C C1 C2 C3 C1 C2 C3 C1 C2 1 aa bbb 1 ccc ddd 1 eee 2 fff ggg 2 hhh iii 2 jj 3 lll mmm 3 nn ooo 4 ttt 4 ppp qq 4 rrr sss The result I wanna have: 1 aa bbb ccc ddd eee 2 fff ggg hhh iii jj 3 lll mmm nn ooo 4 ppp qq rrr sss ttt
TIA /// J Received on Thu Oct 18 2001 - 08:01:10 CDT