Very Computer

by **viva** » Sat, 18 Dec 1999 04:00:00

I have the following tables,
Employee( filelds are EmpID,Name)
Example EmpID Name
1 John
2 Murray
3 Luther
4 Sharon
Supervisors(fields are EmpID,SupervisorEmpID)
Example EmpId SupervisorID
1 2
2 3
3 4
I want to retrieve the names of Employees and their supervisors
the result should be something like,
Emp Name Supervisor Name
John Murray
Murray Luther
Luther Sharon

Thanks in advance

by **Andrea Ballar** » Sat, 18 Dec 1999 04:00:00

select e.Name, s.Name
from Employee e, Supervisor s
where s.SupervisorID = e.EmployeeID

>I have the following tables,
>Employee( filelds are EmpID,Name)
>Example EmpID Name
> 1 John
> 2 Murray
> 3 Luther
> 4 Sharon
>Supervisors(fields are EmpID,SupervisorEmpID)
> Example EmpId SupervisorID
> 1 2
> 2 3
> 3 4
>I want to retrieve the names of Employees and their supervisors
>the result should be something like,
>Emp Name Supervisor Name
>John Murray
>Murray Luther
>Luther Sharon

>Thanks in advance

by **Andrea Ballar** » Sat, 18 Dec 1999 04:00:00

I accidently left out a join that was needed:

select e.Name, s.Name
from Employee e, Employee s, Supervisors su
where su.empid = e.empid
and su.supervisorid = s.empid

Sorry about that.... (blame it on the flu)

Andrea Ballard
Database Analyst
IPS-Sendero

>select e.Name, s.Name
>from Employee e, Supervisor s
>where s.SupervisorID = e.EmployeeID

>>I have the following tables,
>>Employee( filelds are EmpID,Name)
>>Example EmpID Name
>> 1 John
>> 2 Murray
>> 3 Luther
>> 4 Sharon
>>Supervisors(fields are EmpID,SupervisorEmpID)
>> Example EmpId SupervisorID
>> 1 2
>> 2 3
>> 3 4
>>I want to retrieve the names of Employees and their supervisors
>>the result should be something like,
>>Emp Name Supervisor Name
>>John Murray
>>Murray Luther
>>Luther Sharon

>>Thanks in advance

by **Ramda** » Tue, 21 Dec 1999 04:00:00

select a.name,b.name
from employees a,employees b,supervisors c
where b.empid=c.SupervisorEmpID and
c.empid=a.empid

>I have the following tables,
>Employee( filelds are EmpID,Name)
>Example EmpID Name
> 1 John
> 2 Murray
> 3 Luther
> 4 Sharon
>Supervisors(fields are EmpID,SupervisorEmpID)
> Example EmpId SupervisorID
> 1 2
> 2 3
> 3 4
>I want to retrieve the names of Employees and their supervisors
>the result should be something like,
>Emp Name Supervisor Name
>John Murray
>Murray Luther
>Luther Sharon

>Thanks in advance

Very Computer

How Do i write a SQL query for this - Plz HELP URGENT

How Do i write a SQL query for this - Plz HELP URGENT

How Do i write a SQL query for this - Plz HELP URGENT

How Do i write a SQL query for this - Plz HELP URGENT

How Do i write a SQL query for this - Plz HELP URGENT