h**d 发帖数: 474 | 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****n 发帖数: 53 | 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**d 发帖数: 474 | 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****n 发帖数: 53 | 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**d 发帖数: 474 | 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.
|
|