Hi Shyam, Did you see this section of the manual? http://www.jooq.org/doc/3.3/manual/sql-building/sql-statements/insert-statement/#N112DB
What particular issues are you having with the INSERT .. SELECT API? How could it be improved? Best Regards, Lukas 2014-02-17 12:21 GMT+01:00 Sha <[email protected]>: > Hi Lukas, > I have scenario where I need to insert a few(specific) column fields > from another table. > Example > > INSERT INTO tbl_temp2 (fld_id) > SELECT tbl_temp1.fld_order_id > FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; > > > Is there any simpler way in jOOQ ? Current one mentioned in User guide pretty > laborious. > > > Thank you. > > ~Shyam > > -- > 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. > -- 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.
