ALTER TABLE VS4TJobProduction ADD
	TJPdTJobRevision smallint NULL
GO
UPDATE VS4TJobProduction  SET TJPdTJobRevision=(SELECT TJobRevision FROM VS4TJOB WHERE TJPdTJbMTJobNo=TJobNo)
GO
UPDATE VS4TJobProduction  SET TJPdTJobRevision=0 WHERE TJPdTJobRevision is null
GO