MySQL 공부 5(JOIN)

출처 : W3C school

 

INNER JOIN(LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN)
Orders(OrderID, CustomerID)

Customers(CustomerID, CustomerName) 이 있을때

(OrderID, CustmerName)테이블 구하기

SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;