Changeset 27839 for branches/simmosaic_branches/ippTools/share/flatcorr_chiprundone.sql

Timestamp:

May 3, 2010, 8:45:22 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simmosaic_branches

Files:

• . (modified) (1 prop)
• ippTools/share/flatcorr_chiprundone.sql (modified) (2 diffs)

branches/simmosaic_branches/ippTools/share/flatcorr_chiprundone.sql

@@ -1 +1 @@
 SELECT
     corr_id,
-    cam_id,
     chipRun.*
 FROM flatcorrRun
@@ -8 +7 @@
 JOIN chipRun
     USING(chip_id)
-LEFT JOIN camRun
-    ON chipRun.chip_id = camRun.chip_id
+LEFT JOIN flatcorrCamLink
+    using(corr_id, chip_id)
 WHERE
     flatcorrRun.state = 'new'
     AND flatcorrChipLink.include = 1
     AND chipRun.state = 'full'
-    AND camRun.cam_id is NULL;
+    AND flatcorrCamLink.corr_id is NULL