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!