使用database时经常会用到inner join, outer join, left join之类的连接,总是一堆表和code混在一起讲的不太清楚,今天就干脆借用一下韦恩图来表述一下联表方式的区别
1)inner join
2)full outer join (full join)
3)left join
4)right join
5)left outer join
6) right outer join
使用database时经常会用到inner join, outer join, left join之类的连接,总是一堆表和code混在一起讲的不太清楚,今天就干脆借用一下韦恩图来表述一下联表方式的区别
1)inner join
2)full outer join (full join)
3)left join
4)right join
5)left outer join
6) right outer join