The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
▼
Friday, October 18, 2024
SQL _ Update statement using selection of same table or different table
Hi,
update TableA
set TableA.Image = TableB.Image from ( select Image from TableA where dataAreaid = 'USMF' and imagetype = 1) as TableB
where dataAreaid = 'USF1' and imagetype = 1
No comments:
Post a Comment