there should not be question marks in front of INNER JOIN
SELECT product.*, quality.QualityName, country.CountryName, copyright.CopyrightName, materials.MaterialName, palettes.PaletteName
FROM product
INNER JOIN quality ON product.QualityID=quality.QualityID
INNER JOIN county ON product.CountryID= country.CountryID
INNER JOIN copyright ON product.CopyrightID=copyright.CopyrightID
INNER JOIN materials ON product.MaterialID=materials.MaterialID
INNER JOIN palettes ON product.PaletteID=palettes.PaletteID
WHERE ProductID = colname