Last answered:

23 Jan 2023

Posted on:

21 Jan 2023


Error code: 1052

Hello, how to solve:
Error Code: 1052. Column 'emp_no' in where clause is ambiguous

Thank you.

1 answers ( 0 marked as helpful)
Posted on:

23 Jan 2023


Hi Gonzalo!
Thanks for reaching out.

This means you have missed to designate which table does the emp_no field in your code is referring to. Most probably, this happens while you are indicating the columns on which you want to match the two tables.

Hope this helps.

Submit an answer