MySQL - Unknown column when use LEFT JOIN

Question

I'm getting some problems making a simple SELECT w/ LEFT JOIN query:

SELECT 
   a.sttgs_id, a.sttgs_description, 
   (c.uss_id IS NOT NULL) as has 
FROM 
   (mt_user b, mt_settings a 
       LEFT JOIN mt_user_settings c 
             ON c.sttgs_id=a.sttgs_id AND 
             b.usr_id=c.usr_id
   )
WHERE  c.usr_id=2

PHPMyAdmin says: #1054 - Unknown column 'b.usr_id' in 'on clause'.

I really don't know other way to do the SELECT.

Greetings.

Edit: show create table mt_user

enter image description here

mt_user has: usr_id, usr_login, usr_passwd, usr_firstname, etc... — Jhonatan Sandoval
– Jhonatan Sandoval, Commented Mar 21, 2014 at 14:44
Do not mix implicit (comma-) and explicit JOIN syntax. In fact. Don't use implicit join syntax at all — Strawberry
– Strawberry, Commented Mar 21, 2014 at 14:47

echo_Me · Accepted Answer · 2014-03-21 15:02:32Z

1

Try this

SELECT 
      a.sttgs_id, 
      a.sttgs_description, 
      c.uss_id  as has 
FROM mt_user b 
LEFT JOIN mt_user_settings c on b.usr_id=c.usr_id
LEFT JOIN  mt_settings a ON c.sttgs_id=a.sttgs_id  --you may need INNER JOIN here
WHERE  c.usr_id=2
AND c.uss_id IS NOT NULL

edited Mar 21, 2014 at 15:02

answered Mar 21, 2014 at 14:44

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

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

1 Comment

Jhonatan Sandoval Over a year ago

Well, It didn't solve my problem. But i created another post to specify why i want to do this: stackoverflow.com/questions/22562855/… . Thank you for answer.

Collectives™ on Stack Overflow

MySQL - Unknown column when use LEFT JOIN

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related