On 11/28/11 4:36 AM, JavaNoobie wrote:
> Well I'm not fond of using a temporary table either. But how would I be able
> to iterate over a set of consumers while using a join ? From my (limited) ,
> using only a join I would only be able to generate the data for a particular
> consumer , rather than all of them.
get rid of
db_consumer_pump_details.consumer_id=i and
and the limit, and the join will do all of them. But, maybe I don't
quite understand what it is you're doing.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast