Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Unanswered: select statement

    why can't I perform a query of the bellow pattern :


    select field1,field2 from select_statement1,select_statement2.

    note:
    select_statement1/2 are select statement which pruduce valid tables.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: select statement

    Works on V7.2 FP6 ..

    Just for an example,

    select t1.tname,cols from (select tabname from syscat.tables where ) as t1(tname),(select tabname,colname from syscat.columns) as t2(tname,cols) where t1.tname='SYSTABLES' and t1.tname=t2.tname

    What version are you on ? What error message do you get.

    HTH

    Cheers

    Sathyaram


    Originally posted by ilang
    why can't I perform a query of the bellow pattern :


    select field1,field2 from select_statement1,select_statement2.

    note:
    select_statement1/2 are select statement which pruduce valid tables.

  3. #3
    Join Date
    Jul 2002
    Posts
    3

    Very Helpful !

    Thanks a lot !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •