How to use Nested Query in From Clause with SQLCE?

I have been looking at many web posting stating that "Nested Query in FROM clause" works with SQL Compact Edition 3.5 SP1.  I have tried many selects but continue to get
Major Error 0x80040E14, Minor Error 25501
> select volser from (select * from tif)
There was an error parsing the query. [ Token line number = 2,Token line offset = 1,Token in error = ) ]
This query is as simple as I can make it - display one field from a subquery that selects all rows from a table it exist in.
The status line on SSMS recognizes and states that I have SQL CE 3.5.5692.0 installed.
Any suggestions?
select volser from (select * from tif)

Open in new window

tonysapAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please try to give the subquery an alias name:
select volser from (select * from tif) sq

Open in new window

0
 
tonysapAuthor Commented:
In none of the examples did I see a reference to naming the subquery - tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.