Multiple outer joins

Database
N/A

Multiple outer joins

Hi,
i have to convert an oracle sql into teradata that has multiple left outer joins

In oracle
select .... from a,b,c
where
a.id=b.id(+) and
a.id=c.id(+)

With teradata i am able to do one left outer join as:
select ... from a left outer join b
on a.id=b.id

How can i do multiple joins?

Thanks,
-srinivas yelamanchili
2 REPLIES

Re: Multiple outer joins

Hi Srini,
U can use like the following.
Sel ... from
A
LEFT OUTER JOIN
B
ON A.id = B.id
LEFT OUTER JOIN
c
ON A.id = C.id

Hope this could hep U...

Cheers.,
Nagarjun Marri

Re: Multiple outer joins

And Beware of left Joins that are not left joins..

Please see a few slides from TeraTeamUK's "SQL Performance Course". One of the many topics is something we come accross regularly, where developers code left joins but in fact get an inner join.

See the attached word doc.