Hi, I have a doubt about merge statement, I need update the record when EXISTS and its status is NOT resolved and LastUpdate < newRecord.lastUpdate , and INSERT when NOT EXISTS. the query is like this: merge into mybucket using (select id from mybucket where lastUpdate < newRecord.lastUpdate and …

MERGE statement

rodrigo.rio November 3, 2016, 5:29pm 10

sorry, mybucket and APP_mybucket_DATA is the same bucket. Error when i typed

regards