Changeset 38359 for trunk/ippTools/share

Timestamp:

Jun 3, 2015, 11:27:23 AM (11 years ago)

Author:

heather

Message:

changes to do diff addtool by ra /dec ranges

File:

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

trunk/ippTools/share/addtool_find_diff_id_dvo.sql

@@ -3 +3 @@
      diffInputSkyfile 
 JOIN diffSkyfile using (diff_id, skycell_id) 
-JOIN diffRun using (diff_id)
-
+JOIN diffRun using (diff_id,tess_id)
+JOIN skycell using (skycell_id, tess_id) 
+                   JOIN warpRun on (warp1 = warp_id 
+                   AND diffInputSkyfile.skycell_id = skycell_id) 
+                   JOIN fakeRun using (fake_id) 
+                   JOIN camRun using (cam_id) 
+                   JOIN chipRun using (chip_id)  
+                   JOIN rawExp using (exp_id) 
 WHERE diffRun.state = 'full' and diffSkyfile.quality = 0
     AND diffRun.diff_id NOT IN (SELECT diffRun.diff_id