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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!