INNERLEFTRIGHTJOIN語句_MySQL

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 創(chuàng)建出表，表內(nèi)數(shù)據(jù)如下： SQL語句執(zhí)行結(jié)果圖片在語句的下方 Sql代碼 #inner join SELECT A.*,B.* FROM a INNER JOIN B ON a.a1=b.a2 Sql代碼 #left join SELECT A.*,B.* FROM a LEFT OUTER JOIN b ON a.a1 = b.a2 Sql代碼 #right join SELECT A.*,B.* FROM a RIGHT OUTER JOIN b ON a.a1 = b.a2 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 Sql代碼 SELECT A.*, B.* FROM A,B Sql代碼 SELECT A.*,B.* FROM a JOIN b ON a.a1 = b.a2 默認(rèn)是inner join

bitsCN.com

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com