使用(+)操作符指定外连接
如果使用(+)操作符指定外连接,必须使用where子句指定连接条件。
例如:表a,表b
a.i(+)=b.j 右连接
a.i=b.j(+)左连接
如果使用(+)操作符指定外连接,必须使用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