On 8/8/06, Peter Joran <[EMAIL PROTECTED]> wrote:
All
I'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request?
Many Thanks!
Pete
Oracle
AR7
For Example:
SELECT C536870913,C536870914,C536870915
FROM T191
WHERE C536870913 != 'SID25'
AND
C536870914 IN
(SELECT C536870914
FROM T191
WHERE C536870913 = 'SID25'
AND
C536870915 IN
(SELECT C536870915
FROM T191
WHERE C536870913 = 'SID25'))
ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used
solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please
notify us immediately at [EMAIL PROTECTED]. With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate
either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
