Summer Lewis

One query will use a natural join

I didn't finish all of them, but I did my best! This is a link to all of them.

December 17, 2016 at 1:17 PM
Last updated about 8 years ago
Visible to public

Google Docs

MODULE 3 :: TASK 1

Task 1 >> NATURAL JOIN SELECT * FROM Customers NATURAL JOIN Orders; --Task 2 >> INNER JOINS SELECT * FROM Orders INNER JOIN Products USING (ItemNumber); SELECT Orders.OrderNumber, Customers.Address, ItemNumber, ItemDescription, ItemLocation FROM Products INNER JOIN Orders USING (ItemNumber)...