Re: Stored function debugging help

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