Mysql join囂鞘議單晒
<貧匯准
和匯准>
Mysql4.1蝕兵屶隔SQL議徨臥儂。宸倖室宝辛參聞喘SELECT囂鞘栖幹秀匯倖汽双議臥儂潤惚?隼朔委宸倖潤惚恬葎狛陀訳周喘壓総匯倖臥儂嶄。聞喘徨臥儂辛參匯肝來議頼撹載謹貸辞貧俶勣謹倖化帶嘉嬬頼撹議SQL荷恬?揖扮匆辛參閲窒並暦賜宀燕迄棒?旺拝亟軟栖匆載否叟。徽頁?嗤乂秤趨和?徨臥儂辛參瓜厚嗤丼楕議銭俊JOIN紋旗。
邪譜厘断勣繍侭嗤短嗤匡汽芝村議喘薩函竃栖?辛參喘和中宸倖臥儂頼撹?
SELECT * FROM customerinfo WHERE CustomerID NOT in (SELECT CustomerID FROM salesinfo )
泌惚聞喘銭俊JOIN栖頼撹宸倖臥儂垢恬?堀業繍氏酔載謹。喩凪頁輝salesinfo燕嶄斤CustomerID秀嗤沫哈議三?來嬬繍氏厚挫?臥儂泌和?
SELECT * FROM customerinfo
LEFT JOIN salesinfoON customerinfo.CustomerID=salesinfo.CustomerID
WHERE salesinfo.CustomerID IS NULL
銭俊JOIN岻侭參厚嗤丼楕匯乂?頁咀葎 MySQL音俶勣壓坪贋嶄幹秀匝扮燕栖頼撹宸倖貸辞貧議俶勣曾倖化帶議臥儂垢恬。
邪譜厘断勣繍侭嗤短嗤匡汽芝村議喘薩函竃栖?辛參喘和中宸倖臥儂頼撹?
SELECT * FROM customerinfo WHERE CustomerID NOT in (SELECT CustomerID FROM salesinfo )
泌惚聞喘銭俊JOIN栖頼撹宸倖臥儂垢恬?堀業繍氏酔載謹。喩凪頁輝salesinfo燕嶄斤CustomerID秀嗤沫哈議三?來嬬繍氏厚挫?臥儂泌和?
SELECT * FROM customerinfo
LEFT JOIN salesinfoON customerinfo.CustomerID=salesinfo.CustomerID
WHERE salesinfo.CustomerID IS NULL
銭俊JOIN岻侭參厚嗤丼楕匯乂?頁咀葎 MySQL音俶勣壓坪贋嶄幹秀匝扮燕栖頼撹宸倖貸辞貧議俶勣曾倖化帶議臥儂垢恬。
<貧匯准
和匯准>