Thread
:
DB Query Help. trying to find missing entries
View Single Post
#
2
(
permalink
)
05-06-2004, 01:43 AM
HardCoded
WebProWorld Veteran
Join Date: Apr 2004
Posts: 447
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
HardCoded
View Public Profile
Send a private message to HardCoded
Find all posts by HardCoded