How to change order of joins, help lease

Hi.
I'm trying to figure out how to change the order of joins, but no luck.
Is there someone who can explain the following to me.

I have three example tables

create table test1 (age number, name varchar2(10))
create table test2 (name varchar2(10), street varchar2(10))
create table test3 (street varchar2(10), dog varchar2(10), age number)

insert into test1 values(32,'Micke');
insert into test1 values(30,'Mats');

insert into test2 values('John',1);
insert into test2 values('Mats',2);
insert into test2 values('Micke',3);

insert into test3 values (1,'Wolf',28);

Age	Name
28	John
30	Mats
32	Micke

/* Why don't I get 35 ? */
/* I can get 35 if I also outer join test2 with test3 but why, since
they both have all the keys ? */
select test1.age,test2.name
from
test1,test3,test2
where
test1.age = test3.age (+) and
test3.street = test2.street (+);

Result.

Age	Name
28	John
30	Mats
32	Micke	

Help please Received on Mon Jun 24 2002 - 10:53:35 CEST