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]