[postmodern-devel] Multiple inner joins ...

[Ralf Mattes]

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