On Jan 31, 2004, at 7:03 AM, Anony Mous wrote:
> Table #1
> employee_id (pk)
> employee_name
>
> Table #2
> teamleader_employee_id
> backup_employee_id
>
> both fields in table 2 need to do a lookup in table 1 to get the name
> of the actual employee. Do I need to use nested queries to accomplish
> this? Any help is greatly appreciated!
I think you could handle this by calling table1 twice, but with
different aliases, like so
SELECT leader.employee_name, backup.employee_name
FROM table1 leader, table1 backup, table2 t2
WHERE
leader.employee_id = t2.teamleader_employee_id AND
backup.employee_id = t2.backup_employee_id
Does that work for you?
Michael Glaesemann
grzm myrealbox com