select * from qmd_dupeRecords order by companyName, customerNumber select operatorId, mfrCustNum from tbl_OPR_ClientOperators with (nolock) where ownerId = 4036 and fsltablecode = 'DST' and companyName = and address = and city = and state = and zipcode = and mfrCustNum = select operatorId, mfrCustNum from tbl_OPR_ClientOperators with (nolock) where ownerId = 4036 and fsltablecode = 'DST' and companyName = and address = and city = and state = and zipcode = and mfrCustNum =