0 points

MySQL MULTIPLES INNER JOIN


dashboard

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/