Redian新闻
>
Help on migrating oracle to db2, outerjoin
avatar
Help on migrating oracle to db2, outerjoin# Database - 数据库
h*d
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,''
avatar
a*n
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,

avatar
h*d
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

avatar
a*n
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?
avatar
h*d
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.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。