Hi all,

I tried to use some more complex queries, they contained subqueries. I will shortly desrcibe the situation:

I have two tables (e.g. test and foo) and want to join them. Furthermore I want to preselect a subset of one of the two tables by adding some conditions (e.g. order the records by attribute c and only choosing the biggest one).

A query could look like the this:

sql>select * from test join (select * from foo order by c limit 1);

The result I receive is the following:

syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or UNION or ')' in: "select * from test join (select * from foo order”

On the other hand, I can run the subquery without the main query and I receive a valid result.

Is there a possibility to use subqueries with an ORDER BY statement without separating them into two independent queries?

Regards

Leo