joins on results of joins

could someone please tell me how you can join a table with the result of another join. With normal, left and right outer joins.

for example:

tablename1 -- with a left outer join on

tablename2(+) = tablename3

any help is most welcome. Received on Sat Jul 14 2001 - 16:06:53 CDT