SQL error codes

6 months ago

0
Votes

1
Answer

select m.dept_no,m.emp_no,d.dept_name
from table dept_manager_dup m
inner join dept_dup d on m.dept_no=d.dept_no

I am running this code at the very beginning of a query file and after hovering my cursor it shows SELECT is not valid at this position
Error Code: 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 ‘table dept_manager_dup m inner join dept_dup d on m.dept_no=d.dept_no’ at line 2

#errors, #select, #SQL

1 Answer

365 Team 6 months ago

Vote Up Vote Down

0
Votes

Hi Neelanjan!
Thanks for reaching out.
The syntax doesn’t require us to write FROM TABLE, but just FROM. In other words, your FROM clause hasn’t been written correctly. Here’s the correct version of your query.

SELECT 
    m.dept_no, m.emp_no, d.dept_name
FROM
    dept_manager_dup m
        INNER JOIN
    dept_dup d ON m.dept_no = d.dept_no;

Hope this helps.
Best,
Martin

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #errors, #select, #SQL.

SQL error codes

SQL error codes

Related questions