Peter,
Have you tried creating a view of the table in question at db level using the nested select?
If not try it and then build a View table from the database view you create of that form, and then build a table field with no qualification on that table..
If however you need to use the EXTERNAL() keyword to dynamically change the nested select, then maybe a enhancement request might be in order...
Cheers
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.
----- Original Message ----
From: Peter Joran <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, August 8, 2006 1:32:14 PM
Subject: Nested SELECT table qualification?
From: Peter Joran <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, August 8, 2006 1:32:14 PM
Subject: Nested SELECT table qualification?
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
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
