Changeset 28465

Timestamp:

Jun 24, 2010, 12:13:09 PM (16 years ago)

Author:

Paul Price

Message:

Fix query.

File:

• branches/pap/ippTools/share/bgtool_towarp.sql (modified) (1 diff)

branches/pap/ippTools/share/bgtool_towarp.sql

@@ -6 +6 @@
 FROM warpBackgroundRun
 JOIN warpRun USING(warp_id)
-JOIN warpSkyfile USING(warp_id)
+JOIN warpSkyCellMap USING(warp_id)
+JOIN warpSkyfile USING(warp_id, skycell_id)
 JOIN chipBackgroundRun USING(chip_bg_id)
 JOIN chipBackgroundImfile USING(chip_bg_id, class_id)
 JOIN chipRun USING(chip_id)
 JOIN rawExp USING(exp_id)
-LEFT JOIN warpBackgroundSkycell USING(warp_bg_id, skycell_id)
+LEFT JOIN warpBackgroundSkyfile USING(warp_bg_id, skycell_id)
 LEFT JOIN Label ON Label.label = warpBackgroundRun.label
 WHERE warpBackgroundSkyfile.warp_bg_id IS NULL