MySQL Syntax error

Question

What's wrong with this code?

FROM product_tag, ps_product_tags_all
LEFT JOIN users ON
users.id = product_tag.lang
LEFT JOIN images ON
images.id = ps_product_tags_all.lang

Error:

Unknown column 'product_tag.lang' in 'on clause'

Does lang actually exist in the product_tag table ;-) – simnom Sep 10 '10 at 08:12 — simnom, Sep 10 '10 at 08:12
please post the table structure and whole query then. – Tomasz Kowalczyk Sep 10 '10 at 08:13 — Tomasz Kowalczyk, Sep 10 '10 at 08:13

score 4 · Answer 1 · answered Sep 10 '10 at 08:13

You are mixing implicit and explicit joins and joining in the wrong order. Try this:

SELECT *
FROM ps_product_tags_all
LEFT JOIN images ON
images.id = ps_product_tags_all.lang, product_tag
LEFT JOIN users ON
users.id = product_tag.lang
WHERE ...

Remember that explicit JOIN has higher precedence than the implicit join from using comma. To avoid this error I would recommend that you always use explicit joins:

SELECT *
FROM ps_product_tags_all
LEFT JOIN images ON images.id = ps_product_tags_all.lang
LEFT JOIN product_tag ON ...
LEFT JOIN users ON users.id = product_tag.lang

good to know, i've always joined without that info and never had such problem. ;] — Tomasz Kowalczyk, Sep 10 '10 at 08:18

score 2 · Answer 2 · answered Sep 10 '10 at 08:11

2

This is not syntax error, but structure error - you don't have "lang" column in "product_tag" table.

answered Sep 10 '10 at 08:11

Tomasz Kowalczyk

10,472
6
52
68

1

This probably isn't the reason why the query is failing. – Mark Byers Sep 10 '10 at 11:42

MySQL Syntax error

2 Answers2

Linked