Hi there, I am rewatching the lesson on Duplicate Records in JOINs and I executed that code in an earlier lecture to prevent the error message but I am still getting the 1055 error message after this: SELECT m.dept_no, m.emp_no, d.dept_nameFROMdept_manager_dup mJOINdepartments_dup d ON m.dept_no = d.dept_noGROUP BY m.emp_noORDER BY dept_no; I am using MacOS 10.15.4 and and Workbench 8.0.19 Let me know how I can solve this? Thanks.

Hi Yunfeng! Thanks for reaching out. Please make sure to reconnect to the server after you execute the relevant SET Statement. Then, the code is indeed correct. To sum up, here's the order in which you need to execute the relevant operations, the second one being pressing the icon that has been underlined in red on the picture below. SET @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', ''); SELECT m.dept_no, m.emp_no, d.dept_nameFROMdept_manager_dup mJOINdepartments_dup d ON m.dept_no = d.dept_noGROUP BY m.emp_noORDER BY dept_no; Hope this helps.Best,Martin

back

Follow this topic

Yunfeng Zhao

Last answered:

May 14, 2020

Posted on:

May 12, 2020

Still get an error message in Duplicate Records lesson

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

May 14, 2020

Submit an answer

Content