导航

Oracle 外连接问题

Posted on 2007-07-03 18:52  小西  阅读(385)  评论(0)    收藏  举报

现在突然对内外连接概念有点模糊,有谁能给解释一下?谢谢!
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表内容全部显示