Changeset 14031 for trunk/ippTools/share/chiptool_processedimfile.sql

Timestamp:

Jul 5, 2007, 4:08:25 PM (19 years ago)

Author:

jhoblitt

Message:

remove stale use of chipProcessedExp

File:

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

trunk/ippTools/share/chiptool_processedimfile.sql

@@ -1 @@
-SELECT
-    chipProcessedExp.*,
+SELECT DISTINCT
     chipProcessedImfile.class_id,
     chipProcessedImfile.uri,
@@ -12 +11 @@
     rawExp.telescope,
     rawExp.filelevel
-FROM chipProcessedImfile
-JOIN chipProcessedExp
+FROM chipRun
+JOIN chipProcessedImfile
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedExp.exp_id = rawExp.exp_id
+    ON chipProcesseImfile.exp_id = rawExp.exp_id
 WHERE
 -- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too