[h2] Re: Merge on condition

2016-11-17 Thread sucram . iphone
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 skre

[h2] Merge on condition

2016-11-17 Thread sucram . iphone
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