SELECT opr.CompanyName, opr.operatorId FROM tbl_OPR_CustAttrbLnks lnk INNER JOIN tbl_OPR_ClientOperators opr ON lnk.Opr_ID = opr.OperatorID WHERE lnk.categoryid = 50 AND lnk.attributeid IN ( SELECT attributeid FROM tbl_OPR_CustAttrbs WHERE attribute LIKE 'Buf -%' ) GROUP BY opr.CompanyName, opr.operatorId SELECT COUNT( attributeid ), attributeid FROM tbl_OPR_CustAttrbLnks WHERE Opr_ID = GROUP BY attributeid HAVING COUNT( attributeId ) > 1