Please read INSERT INTO t4 VALUES ('A', 'DD'); as INSERT INTO t4 VALUES
('', 'DD'); in my previous mail.
Regards
Naveen
-Original Message-
From: Naveen Nahata
Sent: Wednesday, June 25, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Outer join in SQL server - A
This does the same...
SELECT a1, b1, c1, d1
FROM
t1
left join t2 on t1.a=t2.b
left join t3 on t2.b=t3.c
left join t4 on t1.a2=t4.d
Ade
-Original Message-
Sent: 25 June 2003 12:55
To: Multiple recipients of list ORACLE-L
Please read INSERT INTO
I don't know the answer but can suggest some resources:
www.sqlmag.com
www.sqlpass.org/forums
www.sqlservercentral.com/forum
Just to be sure, I went to each of these this morning to make sure they
are still live.
[EMAIL PROTECTED] 06/25/03 02:49AM
Sorry for the SQL Server post, working on
I think this does what you want:
select a1, b1, c1, d1
from t1 left join t2 on t1.a = t2.b
left join t3 on t2.b = t3.c
left join t4 on t1.a2 = t4.d ;
NB--I don't think this is necessarily a mssql question--oracle 9i (at least)
supports the same ANSI-92 standard join
IIRC, the *= from Sybase and SQLServer is placed on the
opposite side of Oracle's (+) for the same affect.
i.e.
ORACLE:
select a.*,
b.*
from a,
b
where a.x(+) = b.x
Sybase/SQLServer:
select a.*,
b.*
from a,
b
where a.x =* b.x
To: Multiple recipients of list ORACLE-L
Subject: Re: Outer join in SQL server - A very simple question
I don't know the answer but can suggest some resources:
www.sqlmag.com
www.sqlpass.org/forums
www.sqlservercentral.com/forum
Just to be sure, I went to each of these this morning to make