Error message: field list is ambiguous?

[jacquesy]

I'm trying to get the following query to work:

SELECT dbManufacturerId, dbManufacturerName, sum( dbModelRating ) / count( dbModelId ) AS average
FROM manufacturer
INNER JOIN model ON model.dbManufacturerId = dbManufacturerId
GROUP BY dbManufacturerId, dbManufacturerName
ORDER BY average DESC
LIMIT 5;

But recieve the following error message:

Column: 'dbManufacturerId' in field list is ambiguous

I have checked and double checked and can't see the problem😕

Does anybody have any ideas?

Thanks!

[jacquesy]

I thought this was how it would be done, I am trying to make a top 5 list of manufacturers from the manuafacturer table based upon the average score of all of its models from the model table, the two tables are joined by dbManufacturerId.

I'm not the hottest when it comes the MySQL, what woud l need to alter?

Thanks.

[trooper]

what its saying is that you have the same field name in more thatn one table.

Make sure you have the table name in front of the field that is in both tables

e.g

tableA.id = tableb.id

or in your case

INNER JOIN model ON model.dbManufacturerId = manufacturer.dbManufacturerId 
GROUP BY TABLENAME.dbManufacturerId, TABLENAME.dbManufacturerName 
ORDER BY average DESC 
LIMIT 5; 

HTH

GM

[jacquesy]

Yep, i've just realised, thanks for your time!