DBMS Inner Join

3개 테이블 join

SELECT o.o_no, o.p_no, p.p_name, o.quantity, m.mem_id, m.m_name, o_regdate, p.price, p.stock, o.state
FROM ordert o
INNER JOIN product p
ON o.p_no = p.p_no
INNER JOIN member m
ON o.mem_id = m.mem_id
WHERE o.mem_id = 'id';