Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 - 08:39:30 CST