DB Query Help. trying to find missing entries

[Gresser]

Hi all,

Basically there are 2 tables, one that holds:
Time: JobID, PhaseID, Hours, Date.
The other has:
Cost: JobID, PhaseID, Cost

What I want to do is check to see if there are any JobID / PhaseID pairs in Time that are not in Cost. If such an entry exist, I would like to insert an entry with (JobID, PhaseID, 0) so my update statement will match and insert the new data.

Thanks for any help!

[HardCoded]

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