Hi, It might be easier to use:
update table1 t1 set columnX = (select some_Value from table2 t2 where ...) where exists (select * from table2 t2 where ...) The query is a bit more verbose, but it will work in all databases I believe. resultSet.absolute(0); //back to the beginning > Use beforeFirst() instead. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
