I'm getting a syntax error - this is what I put in.
This is what I put in:
SELECT product.*, quality.QualityName, country.CountryName, copyright.CopyrightName, palettes.PaletteName
FROM product
?INNER JOIN quality ON product.QualityID=quality.QualityID
?INNER JOIN country ON product.CountryID= country.CountryID
?INNER JOIN copyright ON product.CopyrightID=copyright.CopyrightID
?INNER JOIN palettes ON product.PaletteID=palettes.PaletteID
WHERE ProductID = colname