In a newer release you added support for nested joins. That's very cool and helps us a lot.
But if you try to do this with two left joins it returns an unexpected error if the first left join table does not return any values.
table left join table2 -> works fine even if table2 does not contain any values
table left join table2 left join table3 -> works fine if table2 contains values but failes if table2 does not contain any values.
In a newer release you added support for nested joins. That's very cool and helps us a lot. But if you try to do this with two left joins it returns an unexpected error if the first left join table does not return any values.
table left join table2 -> works fine even if table2 does not contain any values table left join table2 left join table3 -> works fine if table2 contains values but failes if table2 does not contain any values.