Jason - I have roughly 5 ID's that I have to join... how do I combine multiple Join correctly? Here's what i came up with based on your previous message. Of course it doesn't work.
SELECT product.*, quality.QualityName, country.CountryName, copyright.CopyrightName, materials.MaterialName, palettes.PaletteName
FROM product INNER JOIN quality ON product.QualityID=quality.QualityID
FROM product INNER JOIN county ON product.CountryID= country.CountryID
FROM product INNER JOIN copyright ON product.CopyrightID=copyright.CopyrightID
FROM product INNER JOIN materials ON product.MaterialID=materials.MaterialID
FROM product INNER JOIN quality ON product.PaletteID=palettes.PaletteID
WHERE ProductID = colname