Hi, Thanks for reporting this. I have registered #2335 for this problem: https://github.com/jOOQ/jOOQ/issues/2335
I'll have to think about a solution within jOOQ. I'm not sure if there is one for Oracle, SQL Server, DB2 and Sybase SQL Anywhere, where these kinds of subqueries are generated to simulate LIMIT ... OFFSET. Your hypothesis would work at the client site. You should explicitly rename FOLDER.ID and SUBJECT.ID to something like f_id and s_id, as a workaround to avoid this ambiguity Cheers Lukas -- 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.
