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

Timestamp:

Jul 6, 2007, 4:11:56 PM (19 years ago)

Author:

jhoblitt

Message:

remove rawExp.imfile

File:

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

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -12 +12 @@
     (SELECT 
         chipRun.*,
-        rawExp.imfiles,
+        rawImfile.class_id as rawimfile_class_id,
         chipProcessedImfile.class_id
     FROM chipRun
@@ -19 +19 @@
     JOIN rawExp
         ON chipInputImfile.exp_id = rawExp.exp_id
-    JOIN chipProcessedImfile
+    JOIN rawImfile
+        ON rawExp.exp_id = rawImfile.exp_id
+    LEFT JOIN chipProcessedImfile
         ON chipInputImfile.chip_id = chipProcessedImfile.chip_id
         AND chipInputImfile.exp_id = chipProcessedImfile.exp_id
@@ -29 +31 @@
         chipInputImfile.chip_id,
         chipInputImfile.exp_id
-    HAVING rawExp.imfiles = COUNT(chipProcessedImfile.class_id)) as Foo
+    HAVING COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
+    ) as Foo