对äºSQLä¸inner joinãouter joinåcross joinçåºå«ï¼å¦æä½ ä½¿ç¨joinè¿è¡¨ï¼ç¼ºé·çæ
åµä¸æ¯inner join,å¦å¤ï¼å¼åä¸ä½¿ç¨çleft joinåright joinå±äºouter join,å¦å¤outer joinè¿å
æ¬full join.ä¸é¢æéè¿å¾æ 让大家认è¯å®ä»¬çåºå«ã
ç°æä¸¤å¼ è¡¨ï¼Table A æ¯å·¦è¾¹ç表ãTable B æ¯å³è¾¹ç表ãå
¶åæåæ¡è®°å½ï¼å
¶ä¸æ两æ¡è®°å½nameæ¯ç¸åçï¼
1.INNER JOIN 产ççç»ææ¯ABç交é
SELECT * FROM TableA INNER JOIN TableB ON TableA.name = TableB.name
2.LEFT [OUTER] JOIN 产ç表Açå®å
¨éï¼èB表ä¸å¹é
çåæå¼ï¼æ²¡æå¹é
çå以nullå¼å代ã
SELECT * FROM TableA LEFT OUTER JOIN TableB ON TableA.name = TableB.name
3.RIGHT [OUTER] JOIN 产ç表Bçå®å
¨éï¼èA表ä¸å¹é
çåæå¼ï¼æ²¡æå¹é
çå以nullå¼å代ã
SELECT * FROM TableA RIGHT OUTER JOIN TableB ON TableA.name = TableB.name
å¾æ å¦left join类似ã
4.FULL [OUTER] JOIN 产çAåBç并éã对äºæ²¡æå¹é
çè®°å½ï¼åä¼ä»¥nullå为å¼ã
SELECT * FROM TableA FULL OUTER JOIN TableB ON TableA.name = TableB.name
ä½ å¯ä»¥éè¿is NULLå°æ²¡æå¹é
çå¼æ¾åºæ¥ï¼
SELECT * FROM TableA FULL OUTER JOIN TableB ON TableA.name = TableB.name
WHERE TableA.id IS null OR TableB.id IS null
温馨提示:内容为网友见解,仅供参考