Outer Join Problem
From: Mark Miller <mem8321_at_u.cc.utah.edu>
Date: 17 Jun 1994 21:23:10 -0600
Message-ID: <2ttpau$oej_at_u.cc.utah.edu>
Date: 17 Jun 1994 21:23:10 -0600
Message-ID: <2ttpau$oej_at_u.cc.utah.edu>
The solution to the outer join problem about university students / alumni, etc. will work just fine if you replace the ORs separating the outer join clauses with ANDs.
Example
Select A.ssn, B.bs_year, C.ms_year, D.phd_year from
person A, bs_degree B, ms_degree C, phd_degree D
Where
( B.ssn(+) = A.ssn ) AND
( C.ssn(+) = A.ssn ) AND
( D.ssn(+) = A.ssn );
Received on Sat Jun 18 1994 - 05:23:10 CEST