Multiple joins in SQL Server
am 04.01.2008 07:12:31 von narendra vuradi
Hi I have a requirement where in i haev to convert the SQL from Oracle
to the one which will run on the SQL server.
in the Oracle Query i am doing multiple joins, between some 13 tables.
and some of these joins are inner joins and some are Left outer joins.
table1 inner joined with table 2
table2 inner join with table3
table2 inner join with table4
table2 left join with table5
table5 left jin with table6
table6 left jin with table7
table7 left jin with table8
table8 left jin with table9
Any idea how to achieve this??
Tia
naren
Re: Multiple joins in SQL Server
am 04.01.2008 07:31:40 von Ed Murphy
narendra vuradi wrote:
> Hi I have a requirement where in i haev to convert the SQL from Oracle
> to the one which will run on the SQL server.
>
> in the Oracle Query i am doing multiple joins, between some 13 tables.
> and some of these joins are inner joins and some are Left outer joins.
>
> table1 inner joined with table 2
> table2 inner join with table3
> table2 inner join with table4
> table2 left join with table5
> table5 left jin with table6
> table6 left jin with table7
> table7 left jin with table8
> table8 left jin with table9
Easy peasy, e.g.
select
from table1
join table2 on table1.a = table2.a
join table3 on table2.b = table3.b
join table4 on table2.c = table4.c
left join table5 on table2.d = table5.d
left join table6 on table5.e = table6.e
left join table7 on table6.f = table7.f
left join table8 on table7.g = table8.g
left join table9 on table8.h = table9.h
Re: Multiple joins in SQL Server
am 04.01.2008 13:14:21 von Serge Rielau
Narendra,
Assuming on Oracle you don't face the deprecated (+) syntax it should be
identical since the JOIN syntax is SQL Standard. What fails?
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab