Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Problem converting SELECT with embedded SELECTs
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.comReceived on Fri Aug 01 1997 - 00:00:00 CDT
![]() |
![]() |