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