Changeset 24194 for trunk/ippTools/share/disttool_pendingcomponent.sql

Timestamp:

May 15, 2009, 11:35:28 AM (17 years ago)

Author:

bills

Message:

diffRun no longer has an exp_id

File:

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

trunk/ippTools/share/disttool_pendingcomponent.sql

@@ -229 +229 @@
 JOIN diffRun ON stage_id = diff_id
 JOIN diffSkyfile using(diff_id)
-JOIN rawExp using(exp_id)
+JOIN diffInputSkyfile USING(diff_id, skycell_id)
+JOIN warpRun
+    ON warpRun.warp_id = diffInputSkyfile.warp1
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
 LEFT JOIN distComponent 
     ON distRun.dist_id = distComponent.dist_id