| **
Create a database view that performs the nested select
statement, then create a View form in ARS that reads from the view. You
will probably need to include the C1 column in your SELECT, so that you have a
valid field to use as the Request ID column in the View form.
Use the View form as the source for your table field, and give
it a blank qualification or something like "(1 = 1)". (The SELECT
statement in the database view should filter the query results).
HTH,
Thomas
----- Original Message -----
Newsgroups:
gmane.comp.crm.arsystem.general
Sent: Tuesday, August 08, 2006
12:32
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.
__20060125_______________________This posting was submitted with HTML in it___
|
