SELECT * FROM Products INNER JOIN Manufacturers ON Products.ItemManu = Manufacturers.ManuId INNER JOIN Categories ON Products.ItemCat = Categories.CatId INNER JOIN Sizes ON Products.ItemSize = Sizes.SizeId INNER JOIN Colours ON Products.ItemColours = Colours.ColourId WHERE ItemId = ''