SQL之join, inner join, left join, full join

有时图片可以胜过千行文字

[color=gray]说明：不同的数据库 join == inner join 或者 join == full join ，结果不同。
[/color]

[img]http://dl2.iteye.com/upload/attachment/0120/0750/b1e30c31-d053-3ba6-a367-20a24d19b4f4.png[/img]


引用：

http://stackoverflow.com/questions/38549/what-is-the-difference-between-inner-join-and-outer-join


http://www.datamartist.com/sql-inner-join-left-outer-join-full-outer-join-examples-with-syntax-for-sql-server


-