SELECT ProductLine.ProductLineId,
ProductLine.ProductLineName,
ProductCategory.ProductCategoryId,
ProductCategory.ProductCategoryName,
ProductSubCategory.ProductSubCategoryId,
ProductSubCategory.ProductSubCategoryName,
Products.*,ProductExtendedAttributes.*,ProductTypes.ProductTypeName,Brands.BrandLogoFilePath
FROM ProductLine,ProductCategory,ProductSubCategory,Products,ProductExtendedAttributes,ProductTypes,Brands
WHERE ProductCategory.ProductLineId = ProductLine.ProductLineId
AND ProductCategory.ProductCategoryId = ProductSubCategory.ProductCategoryId
AND Products.ProductSubCategoryId = ProductSubCategory.ProductSubCategoryId
AND Products.ProductId = ProductExtendedAttributes.ProductId
AND ProductExtendedAttributes.ProductTypeId *= ProductTypes.ProductTypeId
AND Products.BrandId = Brands.BrandId
AND products.brandid = '8085'
ORDER BY products.productname,ProductExtendedAttributes.UnitCount
Atkins Diet Products & Foods - Vitacost.com