Answer for SQL error codes

https://365datascience.com/dwqa-answer/answer-for-sql-error-codes/ -

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

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy