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

Timestamp:

Jul 5, 2007, 3:16:08 PM (19 years ago)

Author:

jhoblitt

Message:

rename exp_id -> exp_name
rename exp_tag -> exp_id
add add rawExp.exp_tag for use as an external name only

File:

• trunk/ippTools/share/chiptool_completely_processed_exp.sql (modified) (2 diffs)

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -18 +18 @@
         USING(chip_id)
     JOIN rawExp
-        ON chipInputImfile.exp_tag = rawExp.exp_tag
+        ON chipInputImfile.exp_id = rawExp.exp_id
     JOIN chipProcessedImfile
         ON chipInputImfile.chip_id = chipProcessedImfile.chip_id
-        AND chipInputImfile.exp_tag = chipProcessedImfile.exp_tag
+        AND chipInputImfile.exp_id = chipProcessedImfile.exp_id
         AND chipInputImfile.class_id = chipProcessedImfile.class_id
     WHERE
@@ -28 +28 @@
     GROUP BY
         chipInputImfile.chip_id,
-        chipInputImfile.exp_tag
+        chipInputImfile.exp_id
     HAVING rawExp.imfiles = COUNT(chipProcessedImfile.class_id)) as Foo