To group multiple connections, the syntax is as follows (untested on db2)
SELECT * FROM table1 t1 LEFT JOIN ( table2 t2 INNER JOIN table3 t3 ON t3.someId = t2.someId ) ON t2.someId = t1.someId
Same syntax for left join inside LEFT JOIN()
, but please read @ X-Zero's comment
SELECT * FROM table1 t1 LEFT JOIN ( table2 t2 LEFT JOIN table3 t3 ON t3.someId = t2.someId ) ON t2.someId = t1.someId
source share