Changeset 32337 for branches/eam_branches/ipp-20110710/ippTools/share/dqstatstool_definebyquery.sql

Timestamp:

Sep 6, 2011, 11:00:22 AM (15 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/eam_branches/ipp-20110710/ippTools/share/dqstatstool_definebyquery.sql (modified) (1 diff)

branches/eam_branches/ipp-20110710/ippTools/share/dqstatstool_definebyquery.sql

@@ -1 +1 @@
 -- query to identify unique data to bundle
 
-SELECT DISTINCT exp_id,chip_id,cam_id,warp_id,invalid from rawExp 
+SELECT DISTINCT exp_id,chip_id,cam_id,warpRun.warp_id,invalid from rawExp 
         JOIN chipRun USING(exp_id) 
         JOIN camRun USING(chip_id) 
+        JOIN camProcessedExp USING(cam_id)
         LEFT OUTER JOIN fakeRun USING(cam_id) 
         LEFT OUTER JOIN warpRun USING(fake_id)
-        LEFT OUTER JOIN dqstatsContent USING (exp_id,chip_id,cam_id,warp_id)
+        LEFT OUTER JOIN dqstatsContent USING (exp_id,chip_id,cam_id)
 WHERE camRun.state = 'full'