Richard Neill wrote:
> SELECT ( core.demand.qty - viwcs.wave_end_demand.qty_remaining )
> FROM
> core.demand,
> viwcs.previous_wave
> LEFT OUTER JOIN viwcs.wave_end_demand USING ( wid )
> WHERE core.demand.id = viwcs.wave_end_demand.demand_id;
For comparison, how does this do?:
SELECT (core.demand.qty - viwcs.wave_end_demand.qty_remaining)
FROM core.demand,
JOIN viwcs.previous_wave
ON (core.demand.id = viwcs.wave_end_demand.demand_id)
LEFT OUTER JOIN viwcs.wave_end_demand USING (wid);
-Kevin