SQL JOIN 连接

SQL JOIN 连接

INNER JOIN

     选择两个表中具有匹配值的记录（SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;）

sql 中两个表的关联

（SELECT ID, NAME, AGE, AMOUNT FROM CUSTOMERS, ORDERS WHERE CUSTOMERS.ID = ORDERS.CUSTOMER_ID;）