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
Re: Nested SELECT table qualification?
** Have you considered using a Vew form with that SQL statement?On 8/8/06, Peter Joran [EMAIL PROTECTED] wrote: AllI'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!PeteOracleAR7For Example:SELECT C536870913,C536870914,C536870915FROM T191WHERE C536870913 != 'SID25' ANDC536870914 IN(SELECT C536870914FROM T191 WHERE C536870913 = 'SID25'ANDC536870915 IN(SELECT C536870915FROM T191WHERE 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 CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
** Peter, Have you tried creating a view of the table in question at db levelusing the nested select? If not try it and then build aView 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: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 1:32:14 PMSubject: Nested SELECT table qualification? AllI'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!PeteOracleAR7For Example:SELECT C536870913,C536870914,C536870915FROM T191WHERE C536870913 != 'SID25'ANDC536870914 IN(SELECT C536870914FROM T191 WHERE C536870913 = 'SID25'ANDC536870915 IN(SELECT C536870915FROM T191WHERE 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 usedsolely 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, pleasenotify 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) authenticateeither 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 __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
** 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? AllI'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!PeteOracleAR7For Example:SELECT C536870913,C536870914,C536870915FROM T191WHERE 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 usedsolely 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, pleasenotify 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) authenticateeither 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___
Re: Nested SELECT table qualification?
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
Re: Nested SELECT table qualification?
Title: RE: Nested SELECT table qualification? ** Axton: Unless all of the underlying databases support the requested functionality, you will never see it in ARS. Thus, you probably will not see nested queries even if they are quicker and easier. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, August 08, 2006 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: Nested SELECT table qualification? 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 __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
Thanks for the replies! I do have a need to use an EXTERNAL qualification. Pete -Action Request System discussion list(ARSList) arslist@ARSLIST.ORG wrote: - To: arslist@ARSLIST.ORG From: Axton [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Nested SELECT table qualification?
All of the items I listed are supported by every db supported by ARS. Don't think that is the cause for us never seeing these things. Axton Grams On 8/8/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: Unless all of the underlying databases support the requested functionality, you will never see it in ARS. Thus, you probably will not see nested queries even if they are quicker and easier. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, August 08, 2006 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: Nested SELECT table qualification? 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 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org