multiple outer joins - how does that work ?
I'm trying to create a table from 5 other tables using outer joins, but I get
ORA-01417: a table may be outer joined to at most one other table
How can I get round this ? Here's the basis for the table creation -
SELECT COUNT(*) FROM
PILOT.PERSON P
,PILOT.MEMBERSHIP M
,PILOT.HOUSEHOLD H
,PILOT.COMMUNICATION C
,PILOT.BASE G
WHERE P.PRN(+) = M.PRN
AND H.HRN(+) = M.HRN
AND C.MEMBERSHIP_NUMBER(+) = M.MEMBERSHIP_NUMBER
AND G.POSTCODE = H.POSTCODE(+)
Any input would be greatly appreciated.