On Wednesday, 13 September 2023 at 10:00:18 UTC+2 Lukas Eder wrote:
e) If I need to select all columns of a Table while using a join (and possibly also select specific columns from the joined table), what's the safest and most readable way to do that? With "select(BOOK, AUTHOR.ID).from(BOOK).join(AUTHOR)..." I ran into problems when using it together with .unionAll ("column doesn't exist" error), but that might be a different problem (maybe I'll produce an mcve later). Yeah, please report the UNION ALL issue as a bug here: https://github.com/jOOQ/jOOQ/issues/new/choose I investigated this more and after some analysis I think it's not a jooq bug, but rather I build a non correct SQL statement. To keep things separated, I started a new conversation about it: https://groups.google.com/g/jooq-user/c/XTRY0LPs_4g -- 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 jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/8117d42b-0935-497f-863c-1b2f34464288n%40googlegroups.com.