SELECT ColourLinkingTable.id AS ColourLinkingTable_id, ColourLinkingTable.Product, ColourLinkingTable.Colour AS ColourLinkingTable_Colour, Products.id AS Products_id, Products.productCode, Products.Name, Products.Description AS Products_Description, Products.Keywords, Products.Price, Products.Category, Products.Range, Products.Brand, Products.Stock, Products.Image, Products.Thumb, Products.Top10Image, Products.added, Products.ordered, Products.Rank, Products.Show, Products.SRWName, colour.id AS colour_id, colour.colour AS colour_colour, colour.description AS colour_description FROM colour INNER JOIN (Products INNER JOIN ColourLinkingTable ON Products.id = ColourLinkingTable.Product) ON colour.id = ColourLinkingTable.Colour WHERE colour.colour='garnet' garnet Gemstone Jewellery, Zoo Silver Jewellery