Re: create single resultset from multiple sets

[Andy Shellam]

Hi Bryan,

My gut reaction would be to use a temporary table - create the temporary 
table at the start of proc1, run multiple inserts into the temp table 
for the results of proc2, then just before proc1 ends, select from the 
temp table and drop it.

Andy

Cantwell, Bryan wrote:
> I have a procedure (proc1) that calls another procedure (proc2) several
> times. 
> I'd like to make proc1 return the proc2 results in a single resultset.
> How can this be done in mysql 5.0.51?
>
>