| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Urgent - Outer Join
This is a multi-part message in MIME format.
------=_NextPart_000_0025_01C032D7.8A786F80 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hi,
The following is the situation in SQL Server. i am sure the same problem = would come in Oracle.
I have three tables
Table A, Table B and Table C.
Table A is the super table (Master).
Table B is the child table of A.
Table C is another table which is joined with table C.
Table C has got no relation with Table A.
What I want:
I want to get all the rows from table A irrespective of whether their = primary keys are referenced in Table B.But the table B also needs to = reference table C.=20
My query (Skeleton)
Select columnslist from table A, B, C
where table A(PK) * =3D table B(PK)
and table B(PK) =3D table C(PK)
and table C(PK) =3D <some value>
and some other conditions
My error
Table B is a inner member of the outer join clause and it cannot thus = participate in a normal join operation.
I would appreciate if anyone could kindly let me know the cause of the = error and also the solution.
Also where can I find info about the Outer joins white paper.
Any help greatly appreciated.
Thanks and Rgds,
Sanjay Kumar
------=_NextPart_000_0025_01C032D7.8A786F80 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The following is the situation in SQL =
Server. i am=20
sure the same problem would come in Oracle.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have three tables</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Table A, Table B and Table =
C.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Table A is the super table =
(Master).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Table B is the child table of =
A.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Table C is another table which is =
joined with table=20
C.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Table C has got no relation with Table=20
A.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>What I =
want:</STRONG></FONT></DIV>
irrespective of whether their primary keys are referenced in Table =
B.But=20
the table B also needs to reference table C. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><STRONG>My query =
(Skeleton)</STRONG></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Select columnslist from table A, B, =
C</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>where table A(PK) * =3D table =
B(PK)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and table B(PK) =3D table =
C(PK)</FONT></DIV>
 |
 |