My goal was to return every row from the Cands16 in which CID = RecipID. This was the result:

While the MER table does have rows with multiple incidences of the same value for RecipID every incidence of CID in the Cands16 table is unique. I do not want these duplicate rows resulting from my query. So what should I do? I am using SQL Server 2016 Management Studio.