INNER JOIN è¿ç®
ç»å两个表ä¸çè®°å½ï¼åªè¦å¨å
Œ
±å段ä¹ä¸æç¸ç¬¦çå¼ã
è¯æ³
FROM table1 INNER JOIN table2 ON table1.field1 compopr table2.field2
INNER JOIN è¿ç®å¯å为以ä¸å 个é¨åï¼
é¨å 说æ
table1, table2 è®°å½è¢«ç»åç表çå称ã
field1, field2 被èæ¥çå段çå称ãè¥å®ä»¬ä¸æ¯ç±æ°åææçï¼åè¿äºå段å¿
须为ç¸åçæ°æ®ç±»å并å
å«åç±»æ°æ®ï¼ä½å®ä»¬æ é¡»å
·æç¸åçå称ã
compopr ä»»ä½çå
³ç³»æ¯è¾è¿ç®åï¼"=," "<," ">," "<=," ">=," æ "<>."
说æ
å¯ä»¥å¨ FROM åå¥ä¸ä½¿ç¨INNER JOINè¿ç®ã.è¿æ¯ææ®éçèæ¥ç±»åãåªè¦å¨è¿ä¸¤ä¸ªè¡¨çå
Œ
±å段ä¹ä¸æç¸ç¬¦å¼ï¼å
é¨èæ¥å°ç»å两个表ä¸çè®°å½ã
å¯ä»¥ä½¿ç¨ INNER JOIN ä¸é¨é¨è¡¨åå工表éæ©æ¯ä¸ä¸ªé¨é¨ä¸çå
¨é¨åå·¥ãåä¹ï¼å¯ä»¥ä½¿ç¨ LEFT JOINæ RIGHT JOINè¿ç®å建 outer joinï¼ä»èéæ©ææé¨é¨ï¼å³ä½¿æäºå¹¶æ²¡æåå·¥ï¼æææåå·¥ï¼å³ä½¿æäºå°æªåé
å°é¨é¨ï¼ã
è¥è¯å¾èæ¥å
å« Memoæ OLE Objectæ°æ®çå段ï¼ä¼å¯¼è´é误ã
å¯ä»¥èæ¥ä»»ä½ä¸¤ä¸ªç¸åç±»åçæ°å¼å段ãä¾å¦ï¼å¯ä»¥èæ¥ AutoNumberå Longå段ï¼å 为å®ä»¬ç±»åç¸ä¼¼ãä½ä¸è½èæ¥ Single å Double ç±»åçå段ã
ä¸å示ä¾æ¾ç¤ºå¦ä½å¨ç±»æ è¯ç¬¦å段èæ¥ç±»è¡¨å产å表ï¼
SELECT CategoryName, ProductName
FROM Categories INNER JOIN Products
ON Categories.CategoryID = Products.CategoryID;
å¨ä¸é¢ç示ä¾ä¸ï¼ç±»æ è¯ç¬¦æ¯å·²è¢«èæ¥çå段ï¼ä½æ¯å®å¹¶ä¸å
å«å¨æ¥è¯¢è¾åºä¸ï¼å å®å¹¶é被å
å«å¨ SELECT è¯å¥ä¹ä¸ãå¨è¿ä¸ªç¤ºä¾ä¸ï¼è¥è¦å
å«èæ¥å段ï¼å°å段åå
å«å¨ SELECT è¯å¥ä¸ï¼ Categories.CategoryID.
ä¹å¯ä»¥ä½¿ç¨ä¸åè¯æ³ï¼å¨ä¸ä¸ª JOIN è¯å¥ä¸é¾æ¥å¤ä¸ª ON åå¥ï¼
SELECT fields
FROM table1 INNER JOIN table2
ON table1.field1 compopr table2.field1 AND
ON table1.field2 compopr table2.field2) OR
ON table1.field3 compopr table2.field3)];
ä¹å¯ä»¥ä½¿ç¨ä¸åè¯æ³ï¼åµå¥ JOIN è¯å¥ï¼
SELECT fields
FROM table1 INNER JOIN
(table2 INNER JOIN [( ]table3
[INNER JOIN [( ]tablex [INNER JOIN ...)]
ON table3.field3 compopr tablex.fieldx)]
ON table2.field2 compopr table3.field3)
ON table1.field1 compopr table2.field2;
å¨ä¸ä¸ª INNER JOIN ä¹ä¸ï¼å¯ä»¥åµå¥ LEFT JOIN æ RIGHT JOINï¼ä½æ¯å¨ LEFT JOIN æ RIGHT JOIN ä¸ä¸è½åµå¥ INNER JOINã
--------------------------------------------
ORDER BY åå¥
æç
§éå¢æéå顺åºå¨æå®å段ä¸å¯¹æ¥è¯¢çç»æè®°å½è¿è¡æåºã
è¯æ³
SELECT å段表
FROM 表
WHEREéæ©åå
[ORDER BYå段1 [ASC | DESC ][, å段2 [ASC | DESC ]][, ...]]]
å
å« ORDER BY åå¥ç SELECT è¯å¥å
·æ以ä¸å 个é¨åï¼
é¨å 说æ
fieldlist è¦åä»»ä½å段åå«å, SQL å计å½æ°s, éæ©æå® (ALL, DISTINCT, DISTINCTROWæ TOP)æå
¶ä» SELECT è¯å¥ éæ©ä¸èµ·æ£ç´¢çå段å称ã
table ä»å
¶ä¸è·åè®°å½ç表çå称ã欲ç¥æ´å¤ä¿¡æ¯è¯·ç FROM åå¥.
selectcriteria éæ©ååãå¦ææ¤ è¯å¥ å
å«ä¸ä¸ª WHERE åå¥ï¼ Microsoft Jetæ°æ®åºå¼æ ä¼å¨è®°å½ä¸åºç¨WHEREæ¡ä»¶ï¼ç¶åæå¼æåºã
field1, field2 è¦æåºè®°å½çå段åã
说æ
ORDER BY æ¯å¯éçãä¸è¿ï¼å¦æè¦å°æ°æ®ä»¥æåºæ¶ç顺åºæ¾ç¤ºåºæ¥ï¼å°±å¿
é¡»ä½¿ç¨ ORDER BYã
缺çæåºé¡ºåºæ¯ååº (Aè³ Z, 0è³ 9).以ä¸ä¸¤ä¸ªç¤ºä¾é½ç¨éåçå§å¯¹éåå§åæåºï¼
SELECT LastName, FirstName
FROM Employees
ORDER BY LastName;
SELECT LastName, FirstName
FROM Employees
ORDER BY LastName ASC;
为æéå顺åºæåºï¼Z è³ Aï¼9 è³0ï¼ï¼å¿
é¡»å° DESC ä¿çåæ·»å å°è¦éåæåºçæ¯ä¸å段çå°¾é¨ãä¸ä¾éæ©éåèªé并对éåç¨éå顺åºæåºã
SELECT LastName, Salary
FROM Employees
ORDER BY Salary DESC, LastName;
å¦æä½ å¨ORDER BY åå¥ä¸æ æäºå
å« Memoæ OLE Objectæ°æ®çä¸ä¸ªå段ï¼ä¸ä¸ªé误就产çäºãMicrosoft Jet æ°æ®åºå¼æä¸å¯¹è¿äºç±»åçå段æåºã
ORDER BYéå¸¸æ¯ SQL è¯å¥ä¸æåä¸é¡¹ã
ORDER BY åå¥å¯å
å«æ·»å çå段ãé¦å
ç¨ ORDER BYä¹åå举ç第ä¸ä¸ªå段对记å½æåºãç¶å对æ¤å段ä¸çå¼çè®°å½ç¨ç¬¬äºå段å举çå¼è¿è¡æåºï¼ä¾æ¤ç±»æ¨ã
温馨提示:答案为网友推荐,仅供参考