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