Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL question

SQL question

From: JP <orajp_at_hotmail.com>
Date: Thu, 18 Oct 2001 15:01:10 +0200
Message-ID: <9qmjr4$914$1@mailgate.ikea.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US