Ability to perform merge update

[reenimathew]

Is it possible to perform update by joining with another table? I don't see such a capability.
Can someone help with this? I don't want to do sub query as I need to update multiple columns from other table.

UPDATE Products
SET end_date = other.end_date
FROM Products me
JOIN #updates other
ON (me.id = other.id)

[jeffgbutler]

This syntax isn't in the library now. You could easily code this statement by hand and add it to a mapper.

[DaZuiZui]

hope i can help,my idea is to use JOIn to join other tables,and defube ub tge XML mapping file how to execute the sql statement.

<update id="debugFuction" parameterType="UrParameterType">
  UPDATE tmptable1 t1
  JOIN tmptable2 t2 ON (t1.id = t2.id)
  SET t1.testdate = t2.testdate
</update>