17 Oct
2007
17 Oct
'07
2:35 p.m.
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