Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: select ... from (select ...)

    hello,

    is it possible to do a sql order like this

    select count(*) from (select * from table)

    when I want to do this , I have the message

    incorrect syntax near the keyword 'select'
    server message number 102 security 15
    incorrect syntax near ')'

    why ? how to do an order with a subquery in the from clause ?
    Last edited by bagache; 09-18-03 at 08:38.

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    No, you cannot do this except in the very latest version of ASE (12.5.1), which I think is still in beta.
    Thanks,

    Matt

Posting Permissions

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