Hello Stuart, I actually found the issue as some players may not have equipment, I had to > do join left. >
I see > Sorry for the String I was actually printing out the query with getSQL() > and didn't update it! I have another small query how do you get the > increment id when inserting? > As your ID columns are already AUTO_INCREMENT columns, your MySQL database will do that for you. You can explicitly fetch the auto-generated ID using jOOQ's INSERT .. RETURNING syntax, as documented here: http://www.jooq.org/doc/2.6/manual/sql-building/sql-statements/insert-statement/#N10B37 There had also been a Stack Overflow question on that subject, recently http://stackoverflow.com/q/8127378/521799 Cheers Lukas
