SQL Joins   «Prev  Next»

Advanced join - Exercise

Objective Create an SQL statement that will create the join specified.
Given that you have two tables with the following columns:
Table1
CustomerIDLastnameFirstname

Table2
OrderIDCustomerIDQtyOrderdate

Create a SQL statement that will show all customers in the database and, for any customer with an order, the orders on file. When you are done, submit your SQL statement to the tutor.