My opinion on the enhancement request is that BMC will not venture
anywhere near actually using a db for anything above simple select,
insert, update, and delete statements.
Union joins, table field grouping/aggregates (sum, avg, stddev, etc),
sub-queries; keywords like 'in' and 'between'; are all beyond the
capabilities of ARS.
Axton Grams
On 8/8/06, Thomas Bean <[EMAIL PROTECTED]> wrote:
**
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 -----
From: Peter Joran
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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
