Solved

How to use Nested Query in From Clause with SQLCE?

Posted on 2009-04-14
2
685 Views
Last Modified: 2013-11-17
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
Comment
Question by:tonysap
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 24143409
please try to give the subquery an alias name:
select volser from (select * from tif) sq

Open in new window

0
 

Author Closing Comment

by:tonysap
ID: 31570202
In none of the examples did I see a reference to naming the subquery - tks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 5 110
Sql server lock cursor 13 41
crm development 2 36
BULK INSERT most recent CSV 19 18
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now