MySQL MULTIPLES INNER JOIN
Fri Nov 13 2020 21:36:50 GMT+0000 (UTC)
Posted by
@mvieira
#sql
SELECT
orderNumber,
orderDate,
customerName,
orderLineNumber,
productName,
quantityOrdered,
priceEach
FROM
orders
INNER JOIN orderdetails
USING (orderNumber)
INNER JOIN products
USING (productCode)
INNER JOIN customers
USING (customerNumber)
ORDER BY
orderNumber,
orderLineNumber;
content_copy Copy
https://www.mysqltutorial.org/mysql-inner-join.aspx/
Comments