MySQL Forums
Forum List  »  Sybase

Calling Procedure from a Select
Posted by: Eric Hofer
Date: October 10, 2010 02:42AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Calling Procedure from a Select
5429
October 10, 2010 02:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.