Re: Stored function debugging help

On 11/28/11 1:30 AM, JavaNoobie wrote:
> 1) Get a list of all the consumers and store their id's stored in a temp
> table.
> 2) Iterate over a particular table and retrieve values corresponding to each
> value from the above list and store in a temp table.
> 3)Return the temp table.

couldn't that all be done by a JOIN without involving a temporary table,
or iteration?

this seems like a conventional programmers approach to problem solving,
rather than using the power of the relational database.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast