SQL query question - assistance required.

THERE ARE TWO TABLES AS FOLLOWS:         EMP SUPERVISOR                                                         

       EMP_ID					    EMP_ID
       FIRST_NAME				    *EMP_ID	
       LAST_NAME			               DEPT

*EMP_ID IS THE ID FOR SUPERVISOR WRITE A SQL QUERY TO PRODUCE A LIST OF EMPLOYEE NAMES AND THEIR  SUPERVISOR.(PRESUME EACH EMPLOYEE HAS ONLY ONE SUPERVISOR AND A SUPERVISOR MAY  HAVE MORE THAN ONE EMPLOYEE UNDER HIM) Received on Tue Oct 28 1997 - 00:00:00 CST