Error code: 1052

in SQL / SQL Subqueries nested in SELECT and FROM

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

Thank you.

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

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

Error code: 1052

Submit an answer

related questions