作者:Anruoxia52 | 来源:互联网 | 2017-05-12 16:10
bitsCN.com
INNER LEFT RIGHT JOIN语句 Sql代码 CREATE TABLE `a` ( `a1` VARCHAR(10) DEFAULT NULL, `b1` VARCHAR(10) DEFAULT NULL, `c1` VARCHAR(10) DEFAULT NULL ) ENGINE=INNODB DEFAULT CHARSET=utf8 CREATE TABLE `b` ( `a2` VARCHAR(10) DEFAULT NULL, `b2` VARCHAR(10) DEFAULT NULL ) ENGINE=INNODB DEFAULT CHARSET=utf8 创建出表,表内数据如下:
![](http://img.bitscn.com/upimg/allimg/c140719/1405LN2B5620-1423D.jpg)
SQL语句执行结果图片在语句的下方 Sql代码 #inner join SELECT A.*,B.* FROM a INNER JOIN B ON a.a1=b.a2
![](http://img.bitscn.com/upimg/allimg/c140719/1405LN2E3K0-154138.jpg)
Sql代码 #left join SELECT A.*,B.* FROM a LEFT OUTER JOIN b ON a.a1 = b.a2
![](http://img.bitscn.com/upimg/allimg/c140719/1405LN2HA60-163236.jpg)
Sql代码 #right join SELECT A.*,B.* FROM a RIGHT OUTER JOIN b ON a.a1 = b.a2
![](http://img.bitscn.com/upimg/allimg/c140719/1405LN2K1560-1I418.jpg)
Sql代码 #full outer join union SELECT A.*,B.* FROM a LEFT OUTER JOIN b ON a.a1 = b.a2 UNION SELECT A.*,B.* FROM a RIGHT OUTER JOIN b ON a.a1 = b.a2
![](http://img.bitscn.com/upimg/allimg/c140719/1405LN2N43P-1Y240.jpg)
Sql代码 SELECT A.*, B.* FROM A,B
![](http://img.bitscn.com/upimg/allimg/c140719/1405LN2P93P-192Q1.jpg)
Sql代码 SELECT A.*,B.* FROM a JOIN b ON a.a1 = b.a2 默认是inner join
![](http://img.bitscn.com/upimg/allimg/c140719/1405LN2E3K0-154138.jpg)
bitsCN.com