Multiple Joins into the Same Table?

From: <pmurnane_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 22:06:29 GMT
Message-ID: <7du68u$klv$1@nnrp1.dejanews.com>

Folks:

Can anyone give me a nudge in the right direction with a problem?

When I run

SELECT a.employee, a.manager, b.ssn, c.ssn FROM employees a, hrinfo b, hrinfo c
WHERE a.employee = b.name (+) AND a.manager = c.name (+)

I get the same data returned in the 3rd & 4th columns.

Is this type of query disallowed? Is there a simple alternative?

TIA,
--Phil

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 16:06:29 CST