一、table A为基础表,左外连接table B,若要限制B的条件,需加(+),否则会对结果集以B表的条件进行过滤。
DWD_REASON_CODE.CODE(+)=DWR_EDA_CL_TST_DFT.DEFECT_CODE and DWD_REASON_CODE.CODE_TYPE='DEFECTCODE' and DWD_REASON_CODE.FACTORY='CELL' 结果集为DWR_EDA_CL_TST_DFT表中CODE_TYPE='DEFECTCODE' and FACTORY='CELL' 的结果。 改为: DWD_REASON_CODE.CODE(+)=DWR_EDA_CL_TST_DFT.DEFECT_CODE and DWD_REASON_CODE.CODE_TYPE(+)='DEFECTCODE' and DWD_REASON_CODE.FACTORY(+)='CELL' 结果集包括DWD_REASON_CODE.CODE为空的结果。