Changeset 12174 for trunk/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

Mar 1, 2007, 4:57:45 PM (19 years ago)

Author:

jhoblitt

Message:

first pass working chiptool -queuerawexp
normalize chipPending[Exp|Imfile] & chipProcessed[Exp|Imfile]

File:

• trunk/ippTools/share/chiptool_completely_processed_exp.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -12 +12 @@
     ON chipPendingExp.exp_tag = rawExp.exp_tag
 LEFT JOIN chipProcessedExp
-    ON chipPendingExp.exp_tag = chipProcessedExp.exp_tag
+    ON chipPendingExp.chip_id = chipProcessedExp.chip_id
 LEFT JOIN chipPendingImfile
-    ON chipPendingExp.exp_tag = chipPendingImfile.exp_tag
+    ON chipPendingExp.chip_id = chipPendingImfile.chip_id
 LEFT JOIN chipProcessedImfile
-    ON chipPendingExp.exp_tag = chipProcessedImfile.exp_tag
+    ON chipPendingExp.chip_id = chipProcessedImfile.chip_id
 WHERE
-    chipProcessedExp.exp_tag IS NULL
-    AND chipPendingImfile.exp_tag IS NULL
-    AND chipProcessedImfile.exp_tag IS NOT NULL
+    chipProcessedExp.chip_id IS NULL
+    AND chipPendingImfile.chip_id IS NULL
+    AND chipProcessedImfile.chip_id IS NOT NULL
 GROUP BY
-    chipPendingExp.exp_tag
+    chipPendingExp.chip_id
 HAVING rawExp.imfiles = COUNT(chipProcessedImfile.class_id)