stuart_wachsberg
asked on
syntax error for subselect
I am running sql server desktop edition (MSDE 2000).
I need a count of a union:
select count (*) from ( select id from member union select id from dropoffpoint )
Running the above in the Query analyzer SQL Server yields this error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.
Even a simplified version:
select * from (select id from member)
yields the same error.
Can anyone pls try something similar on MSDE? On the fullblown SQL Server?
Any help appreciated....I do not wish to resort to a temp table because it should be unnecessary here.
I need a count of a union:
select count (*) from ( select id from member union select id from dropoffpoint )
Running the above in the Query analyzer SQL Server yields this error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.
Even a simplified version:
select * from (select id from member)
yields the same error.
Can anyone pls try something similar on MSDE? On the fullblown SQL Server?
Any help appreciated....I do not wish to resort to a temp table because it should be unnecessary here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>select * from (select id from member)<<
Same story here, you need to alias your FROM as in :
select * from (select id from member) a
Same story here, you need to alias your FROM as in :
select * from (select id from member) a
ASKER
how did u know, acperkins? Is this unique to sql server? I have never seeen this before.
Thanks for the quick and helpful response.
Thanks for the quick and helpful response.
>>how did u know, acperkins?<<
I think I learned that here <g>
I think I learned that here <g>
ASKER
its rather odd, but u rescued me. thanks again and Happy Holiday.
In Access VBA, you can't count off of the asterisk *, you have to Count(one of your fields). Perhaps SQL Server SQL is the same.
Hope this helps.
-Jim