内连接<inner join>:
《略》
左外连接<left outer join>:
sql语句:
《写法一》:
select t1.id,t2.djbid from t_ldrk_djb t1 left outer join t_jzzyw_yx t2on t1.id = t2.djbid
《写法二》:
select t1.id,t2.djbid from t_ldrk_djb t1,t_jzzyw_yx t2 where t1.id = t2.djbid(+)
效果截图:

|----------------------------------------------------------------------------------------------------------------------------
右外连接<right outer join>:
select t1.id,t2.djbid
from t_ldrk_djb t1 right outer join t_jzzyw_yx t2 on t1.id = t2.djbid
或
select t1.id,t2.djbid from t_ldrk_djb t1,t_jzzyw_yx t2 where t1.id(+) = t2.djbid
效果截图:


被折叠的 条评论
为什么被折叠?



