Hi I am attempting an inner join with MySQL to select data from two different tables one named 'Bank' which has a 4 digit integer with a column 'no' and a 2 digit integer and one named 'Goodness' which has a VARCHAR with a column 'no' and I would like to print all three pieces of data and I cannot figure out why I am receiving this error, here is my code:

`SELECT MAX(Payroll), no 
FROM Bank
INNER JOIN Goodness
ON Bank.no=Goodness.name
WHERE client = 'Josh';`

The error I receive is: Error Code: 1052. Column 'no' in field list is ambiguous

I think it is because both columns are called no? Can someone help please, any help would be greatly appreciated, thanks!