ALTER TABLE VS4TSO ADD
	TSODDestination nvarchar(50) NULL
GO
UPDATE VS4TSO Set TSODDestination = (Select TCouName2 FROM VS4TCountry WHERE TCouCode=(select tarntcouCode from vs4tar where tarncode=TSODtarncode))
GO