sql server - How can I do an UPDATE statement with JOIN in SQL ...

sql server - How can I do an UPDATE statement with JOIN in SQL ...

瀏覽:374
日期:2025-04-26
update (select u.assid as new_assid, s.assid as old_assid from ud u inner join sale s on u.id = s.udid) up set up.new_assid = up.old_assid ......看更多