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.
m.dept_no, m.emp_no, d.dept_name
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.
Thanks for reaching out.
Please go back to the Important – Prevent Error Code: 1055! note and execute the code in it as suggested.
Hope this helps but please get back to us should you need further assistance. Thank you.