mysql error inner join

Question

I used a query like

select a.email,b.vuid 
from user a
,inner join group b on a.uid = b.uid 
where a.email='[email protected]' and a.kid=1 and b.vid=29 
limit 1

but I always get this error.

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 'inner join group b on a.uid = b.uid where a.email='[email protected]' at line 1

I think its because the inner join but I don't know really.. Could someone help me?

FrustratedWithFormsDesigner · Accepted Answer · 2011-06-10 18:02:56Z

4

Remove the , after from user a.

Your query should be:

select a.email,b.vuid
from user a
inner join group b
on a.uid = b.uid
where a.email='[email protected]'
    and a.kid=1 
    and b.vid=29
limit 1

edited Jun 10, 2011 at 18:02

answered Jun 10, 2011 at 17:47

FrustratedWithFormsDesigner

27.7k31 gold badges151 silver badges211 bronze badges

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

Comments

kapa · Accepted Answer · 2011-06-10 17:56:19Z

2

select a.email,b.vuid from user as a inner join group as b on ...

Of course you can omit the as keyword as demonstrated by @FrustratedWithFormsDesigner but in my opinion it is much more readable this way.

edited Jun 10, 2011 at 17:56

answered Jun 10, 2011 at 17:47

kapa

78.9k21 gold badges166 silver badges178 bronze badges

3 Comments

kapa Over a year ago

@Johan Thanks for commenting, could you show me the syntax error?

Johan Over a year ago

You have a ',' before 'inner join'

kapa Over a year ago

@Johan Thanks, I have already edited it out after I posted the answer. You could remove the downvote if you will.

Collectives™ on Stack Overflow

mysql error inner join

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related