Outer join runs differently on SQL Server and Oracle

Oracle 9i:

create table t(i integer)
Table created

insert into t values(1)
1 row inserted

select t1.i i1, t2.i i2
from t t1 left join t t2 on 1=0
0 rows selected
--- I beleive this is wrong

drop table t
Table dropped

the same query against MS SQL Server 2000:

create table t(i integer)
insert into t values(1)
select t1.i i1, t2.i i2
from t t1 left join t t2 on 1=0

i1 i2
----------- -----------
1 NULL
------- I think this is correct

(1 row(s) affected)

drop table t

What do you think Received on Thu Aug 11 2005 - 12:07:45 CDT