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
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance