左(外)连接:
SELECT YC.ID,YD.Cpid
FROM CRM_CALLREPORT YC, CRM_CALLREPORT_TARGET YD
WHERE 1 = 1 AND YC.ID = YD.CRID(+)
等价于
SELECT YC.ID,YD.Cpid
FROM CRM_CALLREPORT YC left join CRM_CALLREPORT_TARGET YD on YC.ID = YD.CRID
右(外)连接:
SELECT YC.ID,YD.Cpid
FROM CRM_CALLREPORT YC, CRM_CALLREPORT_TARGET YD
WHERE 1 = 1 AND YC.ID(+) = YD.CRID
等价于
SELECT YC.ID,YD.Cpid
FROM CRM_CALLREPORT YC right join CRM_CALLREPORT_TARGET YD on YC.ID = YD.CRID