Solved

How to use Nested Query in From Clause with SQLCE?

Posted on 2009-04-14
2
686 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
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.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 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

12 Experts available now in Live!

Get 1:1 Help Now