Sunday, 1 April 2012

To Update the column without using Inner join in SQL Server

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

No comments:

Post a Comment