Question: Help! Doing MYSQL and keep getting this error code: Error Code: 1146. Table 'my_guitar_shop. ' doesn't exist 0.000 sec Here is my code: USE my_guitar_shop;
Help! Doing MYSQL and keep getting this error code: Error Code: 1146. Table 'my_guitar_shop. ' doesn't exist 0.000 sec
Here is my code:
USE my_guitar_shop;
CREATE OR REPLACE 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 c
JOIN addresses ba ON c.billing_address_id = ba.address_id,
JOIN addresses sa ON c.shipping_address_id = sa.address_id ORDER BY last_name, first_name;
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
