在DB2中外连接如何表示？

wymacu

在ORACLE中用（+），DB2中呢？

vlife

上面的帖子回答你了。

shanghainewuser

FROM    OHS.tcl_fsjour AS z
                LEFT OUTER JOIN OHS.tcl_businjour AS y
                on z.branch_code=y.branch_code  AND z.branch_no=y.branch_no AND z.busi_date=y.busi_date AND z.join_date=y.date AND z.join_serialno=y.serial_no and z.business_flag not in (2410,2409,2008,2007)
                LEFT OUTER JOIN KERNEL.vcl_cust_base_info AS a
                ON  z.branch_code = a.branch_code AND z.branch_no = a.branch_no AND z.busi_date=a.busi_date AND z.fund_account=a.fund_acc
                LEFT OUTER JOIN SAPP.tsa_branch_hq_dict_match AS b
                ON  z.branch_code = b.branch_code AND z.entrust_way = b.branch_item_val
                AND b.branch_item_field = 'entrust_way'
                LEFT OUTER JOIN SAPP.tsa_branch_hq_dict_match AS c
                ON  z.branch_code = c.branch_code AND z.bank_no = c.branch_item_val
                AND c.branch_item_field = 'bank_no'

CCBZZP

內連接
INNER JOIN
左外連接
LEFT OUTER JOIN
右外連接
RIGHT OUTER JOIN
完全外連接
FULL OUTER JOIN