update vs4tinventory set tinvapprovestatus=(select tijtapprovestatus from VS4tinventadjust where VS4tinventadjust.TIjtNo=vs4tinventory.tinvno) where tinvtintalias='STOCKADJUST'
GO
update vs4tinventory set tinvcancelstatus=(select tijtcancelstatus from VS4tinventadjust where VS4tinventadjust.TIjtNo=vs4tinventory.tinvno) where tinvtintalias='STOCKADJUST'
GO
update vs4tinventory set tinvconfirmstatus=tinvapprovestatus where tinvtintalias='STOCKADJUST'
GO