现在突然对内外连接概念有点模糊,有谁能给解释一下?谢谢!
1.
内连接是一对一的连接;外连接是一对多的连接
如下: where table_a.id = table_b.id 内连接
where table_a.id = table_b.id(+) 为外连接
2.
内联接:Select Table_a.a,Table_b.b from Table_a,Table_b where table_a.id = table_b.id
外联接: Select Table_a.a,Table_b.b from Table_a,Table_b where table_a.id(+) = table_b.id
3.
外左联接:Select Table_a.a from Table_a a left outer join bwhere table_a.id = table_b.id
外右联接: Select Table_a.a from Table_a a right outer join where table_a.id = table_b.id
全连接: Select Table_a.a from Table_a a full outer join where table_a.id = table_b.id
4.
a.id=b.id(+) ===> a left outer join b on a.id=b.id
a.id(+)=b.id ===> a right outer join b on a.id=b.id
5.
a.id=b.id(+) ===> a表内容全部显示
a.id(+)=b.id ===> b表内容全部显示
浙公网安备 33010602011771号