Changeset 15526 for trunk/ippTools/share/dettool_toresidexp.sql

Timestamp:

Nov 8, 2007, 3:40:09 PM (19 years ago)

Author:

jhoblitt

Message:

fix left join on fault = 0

File:

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

trunk/ippTools/share/dettool_toresidexp.sql

@@ -56 +56 @@
     WHERE
         detRun.state = 'run'
-        AND detResidImfile.fault = 0
+        AND (detResidImfile.fault = 0 || detResidImfile IS NULL)
         AND detResidExp.det_id IS NULL
         AND detResidExp.iteration IS NULL