Im using the following SQL: MERGE INTO TEST_EXPORT KEY (ID) SELECT * FROM TEST WHERE TIME > TEST.TIME AND ID = TEST.ID ; It actually runs without complains, but don't updates the rows where the time is greater..
Help is very appreciated. Den torsdag 17 november 2016 kl. 16:38:25 UTC+1 skrev [email protected]: > > Hi im a new user of H2 database. > > Im using the merge statement to insert data into the database. > > Im looking for anysuggestion to do the following: > > "Merge All data from Table1 into Table2 if Table1.ID = Table2.ID and > Table1.TIME > Table2.TIME" > > > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
