from fi_cont_main m
,fi_contract c,
bd_cubasdoc jf
,bd_cubasdoc yf,
fi_type_para ty
,BD_CURRTYPE ct
,fi_type_para lm
,fi_ratechange_d rcd
,fi_rate_d rd 人家需要连接的表直接写在from后面了,然后在where中写成这样where m.pk_id = c.pk_parent
and c.jiafangunit = jf.pk_cubasdoc
and c.yifangunit = yf.pk_cubasdoc
and m.loanclass=ty.systemname
and c.currencycode = ct.pk_currtype
and m.loanmode = lm.systemname
and c.ratecode = rcd.pk_parent(+)
and rcd.pk_id = rd.pk_parent(+)
尤其是rd.pk_parent(+) (+)什么意思啊,他这种写法和我用left join right join连有什么区别吗
,fi_contract c,
bd_cubasdoc jf
,bd_cubasdoc yf,
fi_type_para ty
,BD_CURRTYPE ct
,fi_type_para lm
,fi_ratechange_d rcd
,fi_rate_d rd 人家需要连接的表直接写在from后面了,然后在where中写成这样where m.pk_id = c.pk_parent
and c.jiafangunit = jf.pk_cubasdoc
and c.yifangunit = yf.pk_cubasdoc
and m.loanclass=ty.systemname
and c.currencycode = ct.pk_currtype
and m.loanmode = lm.systemname
and c.ratecode = rcd.pk_parent(+)
and rcd.pk_id = rd.pk_parent(+)
尤其是rd.pk_parent(+) (+)什么意思啊,他这种写法和我用left join right join连有什么区别吗
是同一个意思。