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.
|
|
