How to use a user-defined function which generates result set in a SQL statement

[cy163]

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;