Is it possible to have one stored procedure reference a result set
generated by another stored procedure that it called?

For example:

sp_2 calls sp_1 to put a result set in a temporary table

sp_2 then does a join with the same temporary table created by sp_1 for a
final result set

I have a common stored procedure that determines access security and is
used by subsequent stored procedures.

Please let me know.

Thanks,

Brandon


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to