Hi, is there a way to join tables in an update query? Had a quick look at the interfaces and I can't find something that would help me here. Is it even feasible for a library like this? I know it works in MySQL and Sql Server, but I don't know if it works with other database servers.
I would like to avoid manual SQL because there is different syntax for MySQL + SQL Server (our current target DBs). Thanks, Sascha PS: Since this is my first post here I want to say that this is an awesome project! Right now I'm refactoring the persistence layer of our product where we had lots of code that creates SQL on the fly for either MySQL or SQL Server. Most of the old stuff worked for both but there were always small differences which made the code a mess. With jooq these problems are (mostly) gone. Great job, and keep at it!
