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
