mysql中left join,right join,inner join,outer join的区别
表A记录如下:
aID aNum
1 a20050111
2 a20050112
3 a20050113
4 a20050114
5 a20050115
表B记录如下:
bID bName
1 2006032401
2 2006032402
3 2006032403
4 2006032404
8 2006032408
1.left
join(左联接)
SELECT
原创
2014-02-10 12:52:28 ·
511 阅读 ·
0 评论