SESSION NAME: Joins and Unions-1.

QUESTION NAME: Join Two Tables.


TABLE DESCRIPTION:
Write a query using a join to determine which items were
ordered by each of the customers in the customers table.

Select the customerid, firstname, lastname, item, and 
price for everything each customer purchased in the
items_ordered table.

The items_ordered table description is as follows:

CODE:
select customers.customerid, customers.firstname, customers.lastname, items_ordered.item, items_ordered.price from customers  JOIN items_ordered ON customers.customerid = items_ordered.customerid