Hello list,
I'm trying to generate a query similar to the following:
SELECT foo, bar, baz
FROM
(SELECT foo FROM ... WHERE ...) AS tmp1
INNER JOIN
(SELECT bar FROM ... WHERE ...) AS tmp2 ON (tmp1.id = tmp2.id)
INNER JOIN
(SELECT baz FROM ... WHERE ...) AS tmp3 ON (tmp2.id = tmp3.id)
How can I express this in S-SQL syntax?
TIA Ralf Mattes
