Calling Procedure from a Select

[Eric Hofer]

I'm considering migrating to MySql from Sybase and am stumped. I too have many stored procedures that are used in other selects, for example:-

select UT.idUser, UT.nmUser, X.report
from Usertable UT
join MyProc () as X on X.idUser = UT.idUser

I see one bright spark suggested turning this into a function. Aside from the amount of work that would entail and inefficiency, it completely misses the point that MyProc returns several rows and serves as a wrapper for some complex processing that I don't want to have to 're-engineer'.

With "MyProc" returning a table, I can join on it, apply predicates, etc. I fail to see how that works in MySql. Or even why it's not implemented.

Anybody with any thoughts on this matter?