Re: SQL query question - assistance required.

SKMGMT wrote:
>
> 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)
Hi,

try this:

e1.lastname || ', ' || e1.firstname as employee, e2.lastname || ', ' || e2.firstname as supervisor from
emp e1, emp e2, supervisor s
where
e1.emp_id=s.emp_id
and
s.*emp_id=e2.emp_id
order by
e1.lastname, e1.firstname

-- 
Regards

M.Gresz    :-)