error with MySQL SQL syntax

Question

Why do I always get a syntax error on the following inner join:

SELECT 'myapp_instagram_shop'.id 
FROM 'myapp_instagram_shop'  
INNER JOIN  'myapp_instagram_shop_picture' 
    ON  'myapp_instagram_shop'.id =  'myapp_instagram_shop_picture'.shop_id;

Error is:

1064 - You have an error in your SQL syntax; check the manual that corresponds to 
your MySQL server version for the right syntax to use near ''myapp_instagram_shop'
INNER JOIN 'myapp_instagram_shop_picture' ON 'sh' at line 1

wrap table names in ` - not quotes - `myapp_instagram_shop` same goes for pseudonyms. `myapp_instagram_shop`.id — Kai Qing
– Kai Qing, Commented Sep 26, 2013 at 2:00

sunysen · Accepted Answer · 2013-09-26 01:59:49Z

2

try

SELECT myapp_instagram_shop.id FROM myapp_instagram_shop  INNER JOIN  myapp_instagram_shop_picture ON  myapp_instagram_shop.id = myapp_instagram_shop_picture.shop_id;

answered Sep 26, 2013 at 1:59

sunysen

2,3711 gold badge15 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error with MySQL SQL syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related