duplicate values error code from SQL course.
towards the end of the lecture, we add a group by m.emp_no into the inner join we made in the previous lesson to filter out duplicate values, I am getting an error code for 1055. I have ran the code mentioned before diving into joins, but I am not sure what else I need to do make sure it can run correctly.
SELECT
m.dept_no, m.emp_no, d.dept_name
FROM
dep_manager_dup m
INNER JOIN
departments_dup d ON m.dept_no = d.dept_no
group by m.emp_no
ORDER BY dept_no; here is what I have when I attempt to run the code.
m.dept_no, m.emp_no, d.dept_name
FROM
dep_manager_dup m
INNER JOIN
departments_dup d ON m.dept_no = d.dept_no
group by m.emp_no
ORDER BY dept_no; here is what I have when I attempt to run the code.
1 answers ( 0 marked as helpful)
Hi Alan!
Thanks for reaching out.
Please go back to the Important - Prevent Error Code: 1055! note and execute the code in it as suggested. https://learn.365datascience.com/courses/sql/introduction-to-joins Hope this helps but please get back to us should you need further assistance. Thank you.
Best,
Martin
Submit an answer
