, 2003 7:44 PM
> 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
&g
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 =*
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 synt
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, workin
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 t
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 serv