Can I call a user-defined function/procedure in a IN clause

[Felix Felix]

Hello ALL,

I am new to MySQl. I am using MySQL ver 5.1.28
I have got two questions.
(1) Can I make a user-defined function return a tabular result.(say, a list of person name)

(2) Can I call the function in a select statement, like

SELECT * FROM Employee_List LEFT JOIN Employee_WorkList on Employee_List.Name = Employ_WorkList.Name WHERE Employee_List.Name IN Tabular_Result_BY_UserFunction;

Edited 1 time(s). Last edit at 10/15/2008 03:44AM by Felix Felix.