INNER JOIN 操作符

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

SQL INNER JOIN 语法

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

或：

SELECT column_name(s)FROM table1JOIN table2ON table1.column_name=table2.column_name;

凝视：INNER JOIN 与 JOIN 是同样的 (交集)。

Demo

SELECT Customers.CustomerName, Orders.OrderIDFROM CustomersINNER JOIN OrdersON Customers.CustomerID=Orders.CustomerIDORDER BY Customers.CustomerName;

Mysql

也能够用上面的写法，等同以下

SELECT Customers.CustomerName, Orders.OrderIDFROM Customers , OrdersWHERE  Customers.CustomerID=Orders.CustomerIDORDER BY Customers.CustomerName;

该文为部分摘要。并又一次组织，原文地址： 获取很多其它的信息