These solutions require running the jOOQ generator first, correct? Is there a way that doesn't require running the generator first? Thank you very much for your help.
On Monday, February 25, 2013 10:53:11 AM UTC-7, Lukas Eder wrote: > > More examples are available in this Stack Overflow question: > http://stackoverflow.com/q/5832803/521799 > > > 2013/2/25 Lukas Eder <[email protected] <javascript:>> > >> Hello, >> >> I'm sure that this Stack Overflow question might help you: >> http://stackoverflow.com/a/14074525/521799 >> >> In essence, you can access a Table's fields through: >> http://www.jooq.org/javadoc/latest/org/jooq/TableLike.html#fields() >> >> Example: >> >> create.select(TABLE1.fields()) >> .select(TABLE2.SPECIFIC_FIELD) >> .from(...) // etc... >> >> >> Hope this helps >> Cheers >> Lukas >> >> 2013/2/25 <[email protected] <javascript:>> >> >> Hi all- >>> I apologize for an ignorant question, but I'm running into an issue with >>> selecting all of the columns from one table, but only a portion from >>> another. Here's an example SQL statement of what I'd like to do: >>> SELECT table1.*, table2.specific_field >>> FROM table1 >>> JOIN table2 ON table1.keyName = table2.keyName >>> WHERE table1.keyName = 'name' AND table1.typeString = 'type' AND >>> table1.intVal = table2.intVal AND table2.intVal = 18 >>> >>> Specifically, I'm struggling with how to handle the SELECT table1.* when >>> I also have table2.specificField. Any assistance people could provide >>> would be greatly appreciated. Thank you and have a nice day. >>> Brian >>> >>> -- >>> 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] <javascript:>. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> > -- 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]. For more options, visit https://groups.google.com/groups/opt_out.
