Changeset 12176 for trunk/ippTools/src/camtool.c

Timestamp:

Mar 1, 2007, 5:02:35 PM (19 years ago)

Author:

jhoblitt

Message:

SQL fixes

File:

• trunk/ippTools/src/camtool.c (modified) (1 diff)

trunk/ippTools/src/camtool.c

@@ -183 +183 @@
             "   rawExp.workdir"
             " FROM camPendingExp"
+            " JOIN chipProcessedExp"
+            "   USING(chip_id)"
             " JOIN chipProcessedImfile"
             "   USING(chip_id)"
             " JOIN rawExp"
-            "   ON chipProcessedImfile.exp_tag = rawExp.exp_tag"
+            "   ON chipProcessedExp.exp_tag = rawExp.exp_tag"
             " LEFT JOIN camProcessedExp"
             "   ON camPendingExp.cam_id = camProcessedExp.cam_id"