1052 - Column 'typeid' in field list is ambiguous

mysql sql mysql-error-1052
stackoverflow002 picture stackoverflow002 · Dec 12, 2012 · Viewed 7.6k times · Source 
select id,pubdate, typeid,aid,jobname,jobdepart,jobplace,jobnumber,jobcontact from
  archives right join jobrt on id=aid where typeid=19

1, table archives have fileds: id,pubdate,typeid...

2, table jobrt have fields:aid,jobname,jobdepart,jobplace,jobnumber,jobcontact, typeid..

3, id=aid

now, i want to select out the id column the jobname,jobplace comlumns when typeid=19,..

thank you

Answer

John Woo picture John Woo · Dec 12, 2012

since two tables: archives and jobrt contains columnName typeID, you need to specify the tableName where the value came from, eg

SELECT    id
        , pubdate
        , jobrt.typeid
        , aid
        , jobname
        , jobdepart
        , jobplace
        , jobnumber
        , jobcontact
FROM    archives
        RIGHT JOIN jobrt
            ON archives.id = jobrt.aid
WHERE   jobrt.typeid = 19

Related questions

1052: Column 'id' in field list is ambiguous

I have 2 tables. tbl_names and tbl_section which has both the id field in them. How do I go about selecting the id field, because I always get this error: 1052: Column 'id' in field list is ambiguous Here's my …

Read More
MySQL - Selecting data from multiple tables all with same structure but different data

Ok, here is my dilemma I have a database set up with about 5 tables all with the exact same data structure. The data is separated in this manner for localization purposes and to split up a total of about 4.5 million …

Read More
How to resolve ambiguous column names when retrieving results?

I have two tables in my database: NEWS table with columns: id - the news id user - the user id of the author) USERS table with columns: id - the user id I want to execute this SQL: SELECT * …

Read More