Table DDL, sample data and expected results would help us to help you. In the absence of that, what does this return?

SELECT DISTINCT rep_id, hcp_cid

FROM SE_Violation_Detection

John