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_nameFROMdep_manager_dup mINNER JOINdepartments_dup d ON m.dept_no = d.dept_nogroup by m.emp_noORDER BY dept_no; here is what I have when I attempt to run the code.

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

back

Follow this topic

Alan Oubre

Last answered:

May 08, 2020

Posted on:

May 07, 2020

duplicate values error code from SQL course.

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

May 08, 2020

Submit an answer

Content