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