UPDATE accounts.dbo.customermaster
SET accounts.dbo.customermaster.Address1 = reservation.dbo.TourOperator.Address
from reservation.dbo.TourOperator
where accounts.dbo.customermaster.TOID = reservation.dbo.TourOperator.TOID
and accounts.dbo.customermaster.CompanyID = reservation.dbo.TourOperator.CompanyID
SET accounts.dbo.customermaster.Address1 = reservation.dbo.TourOperator.Address
from reservation.dbo.TourOperator
where accounts.dbo.customermaster.TOID = reservation.dbo.TourOperator.TOID
and accounts.dbo.customermaster.CompanyID = reservation.dbo.TourOperator.CompanyID
No comments:
Post a Comment