Changeset 12041 for trunk/ippTools/src/warptool.c

Timestamp:

Feb 23, 2007, 6:03:36 PM (19 years ago)

Author:

jhoblitt

Message:

un'fix' -scmap sql
fix -towarped sql

File:

• trunk/ippTools/src/warptool.c (modified) (2 diffs)

trunk/ippTools/src/warptool.c

@@ -676 +676 @@
         " JOIN warpSkyCellMap\n"
         "   USING(warp_id)\n"
-        " JOIN chipProcessedExp\n"
-        "   ON warpSkyCellMap.exp_tag = chipProcessedExp.exp_tag\n"
         " JOIN chipProcessedImfile\n"
-        "   ON chipProcessedExp.exp_tag = chipProcessedImfile.exp_tag\n"
-        "   AND chipProcessedExp.class_id = chipProcessedImfile.class_id\n"
+        "   ON warpSkyCellMap.exp_tag = chipProcessedImfile.exp_tag\n"
+        "   AND warpSkyCellMap.class_id = chipProcessedImfile.class_id\n"
         " WHERE\n"
         "   warpRun.state = 'run'\n" 
@@ -769 +767 @@
         " JOIN warpSkyCellMap\n"
         "   USING(warp_id)\n"
+        " JOIN rawExp\n"
+        "   ON warpSkyCellMap.exp_tag = rawExp.exp_tag\n"
         " JOIN rawImfile\n"
-        "   ON warpSkyCellMap.exp_tag = rawImfile.exp_tag\n"
-        "   AND warpSkyCellMap.class_id = rawImfile.class_id\n"
+        "   ON rawExp.exp_tag = rawImfile.exp_tag\n"
+        "   AND rawExp.class_id = rawImfile.class_id\n"
         " LEFT JOIN warpSkyfile\n"
         "   USING(warp_id, skycell_id, tess_id)\n"