MySQL错误＃1052 from子句中的列是不明确的

Question

Having some issues with a query to my MySQL DB:

"SELECT event_id, area_name FROM tie_in.events LEFT JOIN tie_in.area USING (area_id)"

When I run this query against my DB it returns the error #1052 - Column 'area_id' in from clause is ambiguous.

I have other LEFT JOINs in this query I just removed them for readability and they fetch fine. Any help to resolve this would be greatly appreciated.

Thanks guys!

Answer 1

If multiple tables have columns with the same name then you have to tell the DB which one to take by adding the table name in front of it

SELECT e.event_id, 
       a.area_name 
FROM tie_in.events e
LEFT JOIN tie_in.area a ON a.area_id = e.area_id