left outer join

hi,

i use ms-sql and oracle9 and have some problems with different results of left outer join: i.e.

select count(*) from table1 left join table2 on table2.id=1;

if there is a table2.id = 1, then the results are equal and thats OK, but if there isnt an table2.id = 1, then in ms-sql i get what i expect, the rowcount from table1, under oracle9 i get as result: 0

ummm...should that be this way?
i get also some internal errors (a lot of crash-logs) ORA-03113 with further conditions in selects with above left joins. so there seems to be something wrong in oracle?!

-- 
Andre Grosse