Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    34

    Unanswered: Using select in a from clause.

    Can we use select c1,c2 from (select col1 as c1, col2 as c2 from table1) as c where c1 > 2 in Sybase?

    Thanks

  2. #2
    Join Date
    Sep 2004
    Location
    Stockholm, Sweden
    Posts
    28
    Yeah, but why dont you just create a dummy table and test...

    select c.c1,c.c2 from (select col1 as c1, col2 as c2 from table1) as c where c.c1 > 2

    /Mats

  3. #3
    Join Date
    Jul 2003
    Posts
    34

    select in from clause

    I tried by creating a temp table....encountering the following:

    Incorrect syntax near ')'.

    Thanks for your help.

Posting Permissions

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