my-guitar-shop-database-exersices/Exercise_2.3.sql

SELECT 
     c.first_name AS First,
     c.last_name AS Last,
    a.line1 AS line1,
   a.city AS city,
   a.state AS state,
   a.zip_code AS Address
FROM
    customers c
        INNER JOIN
    addresses a ON c.customer_id = a.customer_id
    	      AND c.shipping_address_id = a.address_id
WHERE
c.shipping_address_id = a.address_id
ORDER BY First ASC;