Last answered:

23 Jan 2023

Posted on:

21 Jan 2023

0

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)
Instructor
Posted on:

23 Jan 2023

0

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.
Best,
Tsvetelin

Submit an answer