Getting syntax error

Question

I am getting syntax error in following statement...but I want to use it by USING STATEMENT.

SELECT user_job.level1,user_job.tab_level,job.money_gain,job.exp_gain,job.energy_required,job.name,job_tem.no LEFT JOIN job USING(job_id) AND LEFT JOIN job_item USING(job_id)

job_id is common in all the tables.

can you split the query on multiple lines, run it again and post the syntax error? — simendsjo
– simendsjo, Commented Jun 25, 2010 at 9:07

jigfox · Accepted Answer · 2010-06-25 09:26:09Z

2

First of all you're missing the FROM in the statement, so mysql knows from which table you're selecting. I'm assuming you're selecting from user_job table since this table is mentioned first in your select statement.

Second there must be no AND between multiple joins.

So you're complete and correct SQL statement should look like this:

SELECT
  user_job.level1,
  user_job.tab_level,
  job.money_gain,
  job.exp_gain,
  job.energy_required,
  job.name,
  job_tem.no
FROM user_job
LEFT JOIN job USING(job_id)
LEFT JOIN job_item USING(job_id)

edited Jun 25, 2010 at 9:26

answered Jun 25, 2010 at 9:11

jigfox

18.2k3 gold badges62 silver badges74 bronze badges

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

Comments

Michał Pękała · Accepted Answer · 2010-06-25 09:16:04Z

1

You are certainly missing FROM. The query could look like this.

SELECT user_job.level1,
  user_job.tab_level,
  job.money_gain,
  job.exp_gain,
  job.energy_required,
  job.name,
  job_tem.no 
FROM job 
  LEFT JOIN user_job USING(job_id)
  LEFT JOIN job_item USING(job_id)

edited Jun 25, 2010 at 9:16

answered Jun 25, 2010 at 9:10

Michał Pękała

2,3895 gold badges23 silver badges32 bronze badges

1 Comment

Himadri Over a year ago

Same answer as Daj pan Spokoj

Maxem · Accepted Answer · 2010-06-25 09:49:12Z

1

You are missing the FROM-clause and as other have pointed out, you don't chain Joins with ANDs.

edited Jun 25, 2010 at 9:49

answered Jun 25, 2010 at 9:07

Maxem

2,6741 gold badge20 silver badges14 bronze badges

5 Comments

jigfox Over a year ago

this is not an answer it should be comment

Maxem Over a year ago

How is it not a valid answer to this question?

jigfox Over a year ago

because it's a question itself, and it doesn't solve his problem.

Maxem Over a year ago

So missing the from clause doesn't cause syntax errors? Anyways I'll change it to be an answer.

jigfox Over a year ago

it does cause on error, but he would have still gotten a syntax error after adding the FROM, because - like you've written now - there was an AND too much.

Collectives™ on Stack Overflow

Getting syntax error

3 Answers 3

Comments

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related