View Single Post
  #2 (permalink)  
Old 05-06-2004, 01:43 AM
HardCoded HardCoded is offline
WebProWorld Veteran
 
Join Date: Apr 2004
Posts: 447
HardCoded RepRank 0
Default

INSERT INTO Cost
SELECT t.JobID, t.PhaseID, 0
FROM Time AS t
LEFT JOIN Cost AS c
ON t.JobID = c.JobID
AND t.PhaseID = c.PhaseID
WHERE c.JobID IS NULL
Reply With Quote