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 -> Problem converting SELECT with embedded SELECTs

Problem converting SELECT with embedded SELECTs

From: Margaret Ngai <margaret_at_synrevoice.com>
Date: 1997/08/01
Message-ID: <01bc9e93$ebd02880$aa57f8ce@laputa>#1/1

I am converting a Sybase SELECT query to Oracle. The problem is that the original statement contains 'embedded' SELECTs as follows:

SELECT T1.F1, (SELECT T2.F1 WHERE T1.F2 = T2.F2) WHERE T1.F3 = 'xxx'

I need this setup because I need the statement to return T1.F1 even if the link to T2 does not exist.

How can I achieve the same result in Oracle? Due to some problem on the custom application I am using, I cannot use stored procedures or UNION.

Thanks for any suggestions.

-- 
Margaret Ngai
E-Mail: margaret_at_synrevoice.com
Received on Fri Aug 01 1997 - 00:00:00 CDT

Original text of this message

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