I want to insert record job allocations only for selected jobs
I know the following code won't work form the WHERE part but this gives you an idea of what I want achieve. TIA.
INSERT INTO dbo.WipJobAllLab(W.Job, Operation, WorkCentre, IExpUnitRunTim, Milestone, IWcRateInd) VALUES(W.Job, 1, '001', 0.01, 'N', 1)
...
"WHERE SELECT W.Job FROM dbo.WipMaster W LEFT JOIN dbo.WipJobAllLab L ON L.Job=W.Job WHERE L.Job IS NULL AND W.Complete<>'Y'"