|
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|