MySQL - Using the result of a Stored Procedure in an Inner Join -
i have mysql stored procedure returns multiple rows. there way use result in inner join table? i've tried:
select errormessage errormessage em inner join user_language(pcompanyid, puserid) l on em.language=l.languageid errorcode = perrorcode order l.languageorder limit 1;
in example, user_language stored procedure returns list of languages in order of preference. intent return error message in user's preferred language.
i found viable solution. within user_language stored proc, create temp table (called userlanguages) can use in inner join.
call user_language(pcompanyid, puserid); select errormessage verrormessage errormessage em inner join userlanguages l on em.language=l.languageid errorcode = perrorcode order l.languageorder limit 1;
Comments
Post a Comment