Hi, I can create a query with jooq, like this:
SELECT * FROM a, b LEFT OUTER JOIN c ON c.x=a.x AND c.y=b.y WHERE a.z=b.z; But this will not work, because it doesn't know a.x in the ON clause. Instead I would need to create the following query, just by adding parentheses around the from tables: SELECT * FROM *(*a, b*)* LEFT OUTER JOIN c ON c.x=a.x AND c.y=b.y WHERE a.z=b.z; How could I achieve this with jooq? -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
