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
Regards,
The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
Hi select ID from SysTableIdView where SysTableIdView .Name = 'CustTable' Regards,
No comments:
Post a Comment