Union & Nested queries 
Author Message
 Union & Nested queries

Quote:
> I tried to do the following query, but it doesn't work.
> IFX=> select 1 IN (SELECT 1 UNION SELECT 2);
> ERROR:  parser: parse error at or near "union"

Not supported currently.  7.1 will handle it...

                        regards, tom lane



Tue, 29 Apr 2003 23:43:06 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ODBC & MDAC 2.5 & nested union queries

2. DB2 on zOs - nested queries & CASE

3. difference nested select union

4. difference nested select union

5. Union All Statement in nested views

6. FW: difference nested select union

7. union of normal select query and rollup query

8. Need help turning OUTER JOIN query into UNION query

9. nested query query

10. UNION and UNION ALL working backwards?????

11. Diff. between UNION and UNION ALL

12. UNION, UNION ALL


 
Powered by phpBB® Forum Software