Newbie Question about Multiple Join in Select

Folks:

I'm getting some strange data back from a SELECT I'm running, and I was wondering if anyone could shed some light on what's happening.

We have two tables Department and Employee. We want to return a list of employees & their manager, with phone numbers. Department contains employee_number & manager_employee_number, and Employee contains employee_number & phone_number.

When I...

SELECT a.employee_name, b.phone_number, a.manager_name, c.phone_number  FROM department a, employee b, employee c  WHERE a.employee_number = b.employee_number (+) AND   a.manager_employee_number = c.employee_number (+)

I always get the same phone number for the employee & the manager (the employee's phone number).

Help? Anyone?

Thanks In Advance,
--Phil

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 01 1999 - 09:04:31 CST