使用（+）操作符指定外连接
使用（+）操作符指定外连接
如果使用（+）操作符指定外连接，必须使用where子句指定连接条件。
例如：表a，表b
a.i(+)=b.j 右连接
a.i=b.j(+)左连接
select T1.ENTITY_ID as "entityId", T1.MERCHANT_CODE as "merchantCode", T1.MERCHANT_NAME as "merchantName", T1.MERCHANT_REALITY_NAME as "merchantRealityName", T1.MERCHANT_ENGLISH_NAME as "englishName", decode(T1.MERCHANT_STATE,'1','审核通过','0','无效','2','未审核','3','审核未通过') as "merchantState", T2.DICT_NAME as "merchantAttribute", decode(T1.E_PAY_IN ,'0','否','1','是') as "ePayIn", decode(T1.DATA_STATE,'0','已注销','1','未注销') as "dataState" from TB_MERCHANT T1 ,TB_DICT_INFO T2 where T1.MERCHANT_ATTRIBUTE(+)=T2.DICT_CODE and T1.DATA_STATE = 1
