Changeset 20706 for trunk/ippTools/share/magictool_chipprocessedimfile.sql

Timestamp:

Nov 12, 2008, 1:42:29 PM (17 years ago)

Author:

bills

Message:

add camProcessedExp.path_base for raw and chip stages so we can find
the astrometry file

File:

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

trunk/ippTools/share/magictool_chipprocessedimfile.sql

@@ -3 +3 @@
     class_id,
     chipProcessedImfile.uri,
-    chipProcessedImfile.path_base
+    chipProcessedImfile.path_base,
+    camProcessedExp.path_base as cam_path_base
 FROM magicRun
 JOIN magicInputSkyfile USING(magic_id)
@@ -19 +20 @@
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)
+JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id)
 JOIN chipProcessedImfile USING(chip_id,class_id)