Join more than 2 tables

I am trying to create the following view in which 4 subqueries are joined. How do I ensure that all project_number values from np are displayed through my join condition? I am currently getting 'ORA-01417: a table may be outer joined to at most one other table'. Leaving off the 2nd and 3rd (+) causes me to lose rows.

Thanks
MS

select np.project_number, m.designer m_designer, e.designer e_designer, p.designer p_designer from new_project np,
(select designer, project_number from

project_team where discipline='M') m,
(select designer, project_number from

project_team where discipline='P') p,
(select designer, project_number from

project_team where discipline='E') e
where

np.project_number(+)=m.project_number and
np.project_number(+)=e.project_number and
np.project_number(+)=p.project_number;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 07 2000 - 21:37:20 CST