Changeset 23331

Timestamp:

Mar 15, 2009, 4:52:31 PM (17 years ago)

Author:

eugene

Message:

failed to join using exp_id; was hitting the db very hard

File:

• trunk/ippTools/share/dettool_tonormalizedstat.sql (modified) (1 diff)

trunk/ippTools/share/dettool_tonormalizedstat.sql

@@ -14 +14 @@
 LEFT JOIN detResidImfile
     ON  detResidImfile.det_id    = detProcessedImfile.det_id
+    AND detResidImfile.exp_id    = detProcessedImfile.exp_id
     AND detResidImfile.class_id  = detProcessedImfile.class_id
     AND detResidImfile.iteration = detRun.iteration