Changeset 12779 for trunk/ippTools/share/warptool_imfile.sql

Timestamp:

Apr 9, 2007, 6:48:46 PM (19 years ago)

Author:

jhoblitt

Message:

add chip_path_base
rename camProcessedExp.path_base -> cam_path_base

File:

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

trunk/ippTools/share/warptool_imfile.sql

@@ -2 +2 @@
     rawImfile.*,
     warpInputExp.cam_id,
-    camProcessedExp.path_base
+    chipProcessedImfile.path_base as chip_path_base,
+    camProcessedExp.path_base as cam_path_base
 FROM warpRun
 JOIN warpInputExp
@@ -10 +11 @@
 JOIN chipProcessedExp
     ON camProcessedExp.chip_id = chipProcessedExp.chip_id
+JOIN chipProcessedImfile
+    ON camProcessedExp.chip_id = chipProcessedImfile.chip_id
 JOIN rawImfile -- is there any reason not to refer back to rawimfiles?
     ON chipProcessedExp.exp_tag = rawImfile.exp_tag