Open
Description
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)
Activity
jeffgbutler commentedon May 17, 2019
This syntax isn't in the library now. You could easily code this statement by hand and add it to a mapper.
DaZuiZui commentedon May 15, 2023
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.