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)