Create a view named customer_addresses that shows the shippingand billing addresses for each customer. This view should returnthese columns from the Customers table: customer_id, email_address,last_name and first_name. This view should return these columnsfrom the Addresses table: bill_line1, bill_line2, bill_city,bill_state, bill_zip, ship_line1, ship_line2, ship_city,ship_state, and ship_zip.
I have this
CREATE VIEW customer_addresses AS
SELECT customer_id, email_address, last_name, first_name,
bill_line1, bill_line2, bill_city, bill_state, bill_zip,
ship_line1, ship_line2, ship_city, ship_state, ship_zip
FROM Customers, Addresses
WHERE Customers.customer_id = Addresses.customer_id
ORDER BY last_name, first_name;
Error Code: 1052. Column 'customer_id' in field list isambiguous
