Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+select\s+subquery\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+select\s+subquery\s*$/: 5 ]

Total 5 documents matching your query.

1. SQL select subquery (score: 1): Author: Carsten Moldrup <cmoldrup AT CSC DOT DK>; Date: Thu, 22 Jul 1999 14:21:43 +0200; Hi I am trying to do a SELECT FROM subquery...... which wont work. ADSM does not like the () in this sql - removing them gives an ANR2904E Unexpected SQL key word token - 'SELECT'. Any ideas ? ADSM s; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-07/msg00931.html (11,081 bytes)
2. Re: SQL select subquery (score: 1): Author: Bill Colwell <bcolwell AT DRAPER DOT COM>; Date: Thu, 22 Jul 1999 09:46:40 -0400; I Admin ref manual states that correlated subqueries are not supported. I don't you if your query is one, but I suspect it is and that is the problem. -- -- -- Bill Colwell Bill Colwell C. S. Draper; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-07/msg00935.html (11,936 bytes)
3. Re: SQL select subquery (score: 1): Author: Geetam Van Der Dussen <geetam AT SCOTPROV.CO DOT UK>; Date: Fri, 23 Jul 1999 10:04:04 +0100; Dear friends I believe that the syntax diagram for the SELECT statement in the manuals has an error in it: In most flavours of SQL the subquery is part of the 'where' clause, not part of the 'from' c; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-07/msg00973.html (13,720 bytes)
4. Re: SQL select subquery (score: 1): Author: Carsten Moldrup <cmoldrup AT CSC DOT DK>; Date: Fri, 23 Jul 1999 11:38:46 +0200; Hi I believe that this subquery function is a part of the SQL93 specs. However, IBM did not implement this function in their DB2 until the recently released version 5. Since subqueries now are possib; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-07/msg00975.html (14,326 bytes)
5. Re: SQL select subquery (score: 1): Author: Geetam Van Der Dussen <geetam AT SCOTPROV.CO DOT UK>; Date: Mon, 26 Jul 1999 10:28:54 +0100; Carsten I agree that subqueries should work. That is what I trying to say in my email to the ADSM list: SUBQUERIES DO WORK, but the syntax diagram in the manual is wrong. The syntax diagram puts the; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/1999-07/msg01048.html (17,040 bytes)

Current List: 1 - 5
Page: [1]