SQL INNER JOIN 关键字 #

INNER JOIN 关键字在表中存在至少一个匹配时返回行。

SQL INNER JOIN 语法 #

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;

或：

SELECT column_name(s)
FROM table1
JOIN table2
ON table1.column_name=table2.column_name;

注释：INNER JOIN 与 JOIN 是相同的。

SQL INNER JOIN 实例 #

MariaDB [learnsql]> select domains.id,domains.domainname,logs.baidu,logs.google from domains inner join logs on domains.id=logs.id order by logs.google;
+----+---------------+--------+--------+
| id | domainname    | baidu  | google |
+----+---------------+--------+--------+
| 47 | manjushri.cn  | 002675 | 000546 |
| 16 | bailuyuan.org | 001534 | 000775 |
| 12 | blbl.dev      | 001324 | 000919 |
|  9 | regex.in      | 002217 | 000945 |
|  8 | les.moe       | 000350 | 001166 |
| 20 | ciux.org      | 000944 | 001394 |
| 19 | unixetc.com   | 000348 | 001467 |
| 22 | suopo.net     | 002344 | 001531 |
| 13 | raspi.in      | 002424 | 001532 |
| 18 | ustv.xyz      | 000390 | 001616 |
| 44 | alair.cn      | 002486 | 001698 |
| 15 | aosp.me       | 002267 | 001724 |
|  4 | getos.org     | 002745 | 001864 |
| 21 | avlist.top    | 000932 | 002042 |
| 52 | mua.wiki      | 002425 | 002147 |
| 50 | byhzg.cn      | 001559 | 002196 |
| 48 | pushto.cn     | 002769 | 002231 |
| 24 | ltecn.com     | 002628 | 002466 |
| 17 | linuxuc.com   | 001155 | 002483 |
| 45 | ymqd.net      | 001089 | 002501 |
|  7 | lyq.wiki      | 000395 | 002543 |
| 14 | pornie.in     | 002840 | 002552 |
| 25 | pornie.top    | 002076 | 002561 |
| 46 | nasplus.cn    | 001891 | 002662 |
| 49 | gfwlist.cn    | 001358 | 002812 |
| 43 | zjq.xyz       | 000137 | 002880 |
|  6 | dotbbq.com    | 002448 | 002927 |
+----+---------------+--------+--------+
27 rows in set (0.007 sec)

注释：INNER JOIN 关键字在表中存在至少一个匹配时返回行。如果 “domains” 表中的行在 “logs” 中没有匹配，则不会列出这些行。