Help on migrating oracle to db2, outerjoin - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Help on migrating oracle to db2, outerjoin

Help on migrating oracle to db2, outerjoin# Database - 数据库

h*d2001-03-08 08:03

1 楼

Is there any outer join operator in DB2?
The following is one of my SQL statement:
CREATE OR REPLACE VIEW BANKREFERENCE_SEARCH_V ( CUSTOMERID,
CUSTOMERNAME, BANKNAME, REFERENCEDATE, ASSIGNEDTOSTR,
ASSIGNEDTO, FOLLOWUPDATE ) AS (
select distinct
customer.customerID as customerId,
customer.NAME as customerName,
br.NameOfInstitution as BankName,
br.referenceDate as ReferenceDate,
su.LastName || decode(nvl(br.assignedTo,-1),-1,'',', ') || su.
FirstName || decode(nvl(br.assignedTo,-1),-1,''

a*n2001-03-08 08:03

2 楼

In DB2, the ourter join operator is
FULL OUTER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN

【在 h**d 的大作中提到】

: Is there any outer join operator in DB2?
: The following is one of my SQL statement:
: CREATE OR REPLACE VIEW BANKREFERENCE_SEARCH_V ( CUSTOMERID,
: CUSTOMERNAME, BANKNAME, REFERENCEDATE, ASSIGNEDTOSTR,
: ASSIGNEDTO, FOLLOWUPDATE ) AS (
: select distinct
: customer.customerID as customerId,
: customer.NAME as customerName,
: br.NameOfInstitution as BankName,
: br.referenceDate as ReferenceDate,

h*d2001-03-08 08:03

3 楼

If table A outer join B,C,D at the same time....how?

【在 a****n 的大作中提到】

: In DB2, the ourter join operator is
: FULL OUTER JOIN
: LEFT OUTER JOIN
: RIGHT OUTER JOIN

a*n2001-03-08 08:03

4 楼

(A OUTER JOIN B ON ...) OUTER JOIN C ON ...
I can not remember the detail, but this is how
it works. I have done this myself before. You
can check the DB2 help file to get more detail
information.

【在 h**d 的大作中提到】

: If table A outer join B,C,D at the same time....how?

h*d2001-03-08 08:03

5 楼

thanks a lot:)

【在 a****n 的大作中提到】

: (A OUTER JOIN B ON ...) OUTER JOIN C ON ...
: I can not remember the detail, but this is how
: it works. I have done this myself before. You
: can check the DB2 help file to get more detail
: information.