Sybase to UDB migration --- help required on joins

[sandip]

Hi all,

I am facing a problem while migrating a Sybase SQL query to DB2 UDB.
The query involves left outer joins.

The Sybase query syntax is as follows :

select * from A, B, C
where A.id1 *= C.id1 and B.id2 *= C.id2

Can anyone please give me the equivalent query in DB2?

Thanks,
Sandip.

[Serge Rielau]

sandip wrote:

Hi all,

I am facing a problem while migrating a Sybase SQL query to DB2 UDB.
The query involves left outer joins.

The Sybase query syntax is as follows :

select * from A, B, C
where A.id1 *= C.id1 and B.id2 *= C.id2

Can anyone please give me the equivalent query in DB2?

I think:
select *
from c
left outer join b
on B.id2 = C.id2
left outer join a
on a.id1 = c.id1

This assumes that the * marks the outer.

cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[sandip]

a.id1 *= b.id1 means a left outer join b on a.id1 = b.id1.

Thanks,
Sandip.

[Serge Rielau]

sandip wrote:

a.id1 *= b.id1 means a left outer join b on a.id1 = b.id1.

Thanks,
Sandip.

OK, then:
select *
from A
left outer join C
on A.id1 = C.id1
left outer join b
on B.id2 = C.id2

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab