Changeset 18023

Timestamp:

Jun 9, 2008, 11:24:03 AM (18 years ago)

Author:

eugene

Message:

need cam_path_base and chip_path_base

File:

• branches/faketool/ippTools/share/faketool_pendingimfile.sql (modified) (2 diffs)

branches/faketool/ippTools/share/faketool_pendingimfile.sql

@@ -21 +21 @@
         chipProcessedImfile.n_cr,
         chipProcessedImfile.n_astrom,
-        chipProcessedImfile.path_base,
+        chipProcessedImfile.path_base as chip_path_base,
+        camProcessedExp.path_base as cam_path_base,
         rawExp.exp_name,
         rawExp.camera,
@@ -28 +29 @@
     FROM fakeRun
     JOIN camRun
+        USING(cam_id)
+    JOIN camProcessedExp
         USING(cam_id)
     JOIN chipRun