Subqueries in select clause 
Author Message
 Subqueries in select clause
Are they allowed for SQL/400?

Something like I can do in SYBASE

select(select user_name from SYS.SYSUSERPERM
      where user_id=SYSTABLE.creator),
    column_name,table_name,
    (select domain_name from SYS.SYSDOMAIN
      where domain_id=SYSCOLUMN.domain_id),
    nulls,width,scale,pkey,column_id,"default",
    SYSCOLUMN.remarks
    from SYS.SYSCOLUMN join SYS.SYSTABLE

Sent via Deja.com
http://www.***.com/



Sat, 19 Jul 2003 22:47:17 GMT
 Subqueries in select clause

Not supported until this's years release of DB2/400 - in beta now.

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries

(opinions stated are not necessarily those of my employer)



Mon, 21 Jul 2003 01:52:37 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Subquery on SELECT clause

2. Using Union subquery in select clause

3. ANSI syntax for a correlated subquery in the SELECT clause

4. Outer reference in SELECT clause of subquery

5. results from SELECT clause used in an IN clause

6. Is it possible to use a SELECT clause in a FROM clause

7. subquery in the from clause?

8. Subqueries Fields in WHERE clause

9. Subquery in FROM clause allowed?

10. Where Clause in Subquery not working

11. Subqueries in From clause

12. Subquery in the FROM clause


 
Powered by phpBB® Forum Software