MS SQLCE - Subquery before FROM

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Subquery before FROM

Teemu

2006-11-18, 7:13 pm

Hello!

This kind of query works well with Access:

SELECT Field1, (SELECT Field2 FROM Table2 WHERE Key=1) AS Field2 FROM Table1

But when I try execute it with SQL Server Everywhere it says "Token in error
= SELECT".

How can I do this kind query with it? I can't use JOIN here, I have to have
subquery before FROM.

I'm sure that my subquery returns only one value so that is not a problem.

-Teemu

Sponsored Links