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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/8117d42b-0935-497f-863c-1b2f34464288n%40googlegroups.com.
