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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
