Inner Join 여러개

SELECT o1.id, o1.customerId, c1.userName, p1.name, p1.price, 100-p1.qty 수량
FROM orders o1 
INNER JOIN customer c1
ON o1.customerId = c1.id
INNER JOIN product p1
ON o1.productId = p1.id;

드라이빙 orders