Hi,

I have this query in Sybase which need to be migrated on DB2.

How will be in DB2 this query ? Please help!
SELECT
a.*
FROM
( SELECT o.business, o.br as br ,o.ord as ord, d.trde as trde
FROM table e, table tf, table o, table d,

WHERE o.business = '2006-01-04'
AND o.source = '7'
AND e.exec *= tf.exec
AND e.exec *= tf.exec
AND e.as *= tf.as
AND o.ord *= e.ord
AND o.ord *= e.ord
AND o.ord *= e.ord
AND o.acct *= d.acct
AND o.acct_no *= d.acct_no

) a, table bd, table bdt
WHERE a.br *= bd.br
AND a.ord *= bdt.bra
AND (a.trde not in ('a','x','w') OR a.trde is null)
;

Thanks.

use LEFT OUTER JOIN instead of *=

Can you please send me the query using left join ?

Thanks.

should be something like

select ...
from (...) a
left outer join bd on a.br=bd.br
left outer join bdt on a.ord=bdt.bra
where (a.trde not in ('a','x','w') OR a.trde is null)

Hi,
Thank you for your answer.

Here is the issue


where (a.trde not in ('a','x','w') OR a.trde is null)

Because trde is a column from an unpreserved table the condition is not correct. If this query is ran it on Sybase and DB2 the result set is different.

So, which can be the solution ?