Inner joinï¼å
è¿æ¥ï¼ä¹å«çå¼è¿æ¥ï¼inner join产çåæ¶ç¬¦åAåBçä¸ç»æ°æ®ã
Cross joinï¼äº¤åè¿æ¥ï¼å¾å°çç»ææ¯ä¸¤ä¸ªè¡¨çä¹ç§¯ï¼å³ç¬å¡å°ç§¯
ç¬å¡å°ï¼Descartesï¼ä¹ç§¯åå«ç´ç§¯ãå设éåA={a,b}ï¼éåB={0,1,2}ï¼å两个éåçç¬å¡å°ç§¯ä¸º{(a,0),(a,1),(a,2),(b,0),(b,1), (b,2)}ãå¯ä»¥æ©å±å°å¤ä¸ªéåçæ
åµã类似çä¾åæï¼å¦æA表示æå¦æ ¡å¦ççéåï¼B表示该å¦æ ¡ææ课ç¨çéåï¼åAä¸Bçç¬å¡å°ç§¯è¡¨ç¤ºææå¯è½çé课æ
åµã
Inner join å Cross join çåºå«ï¼
1ãCross joinçæçæ¯å
çæç¬å¡å°éï¼ç¶åonè¿æ¥æ¡ä»¶è¢«è§ä¸ºäºfilterç¨äºæ°æ®è¿æ»¤ï¼
Inner joinæ¯ç´æ¥åºäºjoin conditionåè¿æ¥ï¼çæçjoinéåå°±æ¯æç»çè¾åºç»æï¼äº§ççä¸é´æ°æ®æ´å°ã
2ãInner joinç»åONåå¥ä½¿ç¨ï¼Cross joinç¨äºå
¶å®å°æ¹ã
3ãCross join产ççæ¯ç¬å¡å°éï¼ä¹å°±æ¯ M*N çéåï¼Inner joinæ¯å
èæ¥è¯¢ï¼ä¸æ¯äº§çç¬å¡å°éã
4ãCross joinä¸å æ¡ä»¶éå¶ï¼Inner joinçonæ¯å äºæ¡ä»¶éå¶ç
温馨提示:答案为网友推荐,仅供参考