Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: FirstName, LastName, Line1, City, State, ZipCode. Code the join so only addresses that are the shipping address for a customer are returned.undefined

Administrators AdminID My Guitar Shop Database Diagram Email Address Password FirstName Orderltems ItemID LastName OrderID ProductID ItemPrice Discount Amount Quantity Products ProductID 8 CategoryID Product Code Orders OrderID CustomerlD Product Name GO Description List Price Order Date Discount Percent Date Added Customers CustomerlD Email Address ShipAmount TaxAmount ShipDate ShipAddressID CardType CardNumber CardExpires BillingAddressID Password FirstName LastName ShippingAddressID BillingAddressID Categories CategoryID CategoryName 0 Addresses AddressID CustomerlD Line 1 Line2 City State ZipCode Phone Disabled 1-1