ALTER TABLE VS4TQuotation ADD
	TQuoDestination nvarchar(50) NULL
GO
UPDATE VS4TQuotation Set TQuoDestination = (Select TCouName2 FROM VS4TCountry WHERE TCouCode=(select tarntcouCode from vs4tar where tarncode=tquotarncode))
GO
UPDATE VS4TQuotation Set TQuoCountryOrigin ='Thailand'
GO