To write a query without using a sub query

Hello all,

I am using a free database called 'MySql'. But unfortunately it does not support sub queries. Can some one help me to write the query without using the sub query.
 For example, my query is something like this:

 SELECT emp_name FROM emp
 WHERE emp_num > 0
   and emp_num NOT IN (SELECT supervisor_emp FROM supervisor). Received on Tue Jul 17 2001 - 07:49:51 CDT