ALTER TABLE VS4TInventory ADD
	TInvSourceType smallint NULL
GO
UPDATE VS4TInventory Set TInvSourceType=(select TInMSourceType From VS4tInventoryMB where VS4TInventory.tinvno=VS4TInventoryMB.Tinmtinvno and VS4TInventorymb.tinmln=1)
WHERE TInvSourceType is null
GO