Way to select t1.*, t2.col1, t2.col2 from ...

[Rob Nikander]

Hi,

Is this possible? Something like select(TABLE1, TABLE2.COL1).from(TABLE1).join(TABLE2). I've got a big join and I don't want every column in 5 tables coming back. But I don't want to explicity list out 20 columns either.

thanks,

Rob

[Lukas Eder]

Hello,

Yes, you can repeat the "SELECT" keyword as such:

 select(TABLE1.fields())

.select(TABLE2.COL1)

.from(TABLE1)

.join(TABLE2)...

Some more examples can be seen in this Stack Overflow question:

http://stackoverflow.com/a/5845043/521799

Cheers

Lukas

2013/9/26 Rob Nikander <rob.ni...@gmail.com>

--
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+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Rob Nikander]

Sweet, thanks!