SELECT DISTINCT styles.style as ProductID, styles.brochurecode as brochurecode, styles.CategoryID, 1 as ProductStateID, styles.SubCategoryID, styles.style AS ProductCode, styles.style_Description AS productDescription, styles.Brand as BrandImage1, productextras.style, productextras.newproduct,productextras.productinfo, productextras.brandimage FROM subCategories, styles INNER JOIN productextras on productextras.style = styles.style WHERE styles.SubCategoryID = subCategories.SubCategoryID AND styles.Brand = 'RE' ORDER BY styles.style