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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Querry

Re: SQL Querry

From: Wayne or Donna Weiselogel <waynerw_at_flash.net>
Date: Tue, 23 Feb 1999 05:50:02 GMT
Message-ID: <ekrA2.934$7p1.1302@news.flash.net>


You might try:
select a.field1, a.field2, b.field3, b.field4, c.field5 from a, b, c
where a.field1 = b.field3 (+)
and a.field1 = c.field5 (+)

User554420 wrote in message
<19990223000436.21910.00001596_at_ng-da1.aol.com>...
>I have a query with several outer joins. For example
> tables a, b, c
>
>select a.field1, a.field2, b.field3, b.field4, c.field5
>from a, b, c
>where a.field1 = b.field3 (+) and
> b.field3 = c.field5 (+)
>
>I'm not getting any rows back when there is no data for tables b & c. I
could
>put this into a couple subqueries, but is there a better way.
>
>Thanks.
>
Received on Mon Feb 22 1999 - 23:50:02 CST

Original text of this message

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