Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 710
  • Last Modified:

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

0
tonysap
Asked:
tonysap
1 Solution
 
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now