SELECT BrandCode, Brand FROM tbl_MFR_Brands WHERE Brand_ID = SELECT MFR_NAME FROM tblManufacturers WHERE MFR_ID = SELECT MFR_NAME FROM tblManufacturers WHERE MFR_ID = SELECT categoryDesc FROM tbl_OFS_Categories WHERE categoryId IN () SELECT MFR_NAME FROM tblManufacturers WHERE MFR_ID =