2017 JAVA 교육수료/DAY
33DAY / mysql / DISTINCT , INNER JOIN
탱탱귤
2017. 5. 22. 11:04
생성
Order.java
OrderDao.java
Order_Customer.java : Order객체와 Customer객체를 SETTING / GETTING 하는 클래스
OrderList.jsp : 출력하는 JSP파일
INNER JOIN
SELECT
FROM
INNER JOIN
ON
select orders.id , orders.date, orders.amount, orders.customer_id, customers.name
from orders
inner join customers
on customers.id = orders.customer_id;
