ALTER TABLE VS4TJobMB ADD
	TjbMShippingMark nvarchar(255) NULL
GO
update vs4tjobmb set tjbmshippingmark=(select tsobshippingmark from vs4tsomb where tjbmsourceno=tsobtsodno and tjbmsourceln=tsobln)
GO