Two combinations of a unique ID

[Dogo23]

Hello,

If I want to select a unique record by ID (mid), and I have two combinations of the ID, how do I pull that from a single table?

Thanks

[novinosrin]

which one do you need to pick from communication_nm as i see those are two different values?

[Dogo23]

It really doesn't matter, it could be random or based on date/time. This is occurring because someone submitted this campaign from an application twice (which is why the ID remains the same), but changed the name of the communication. 

[Reeza]

Try PROC SORT with the NODUPKEY option.

[Reeza]

What do you mean by 2 combinations?

Why doesn't a straightforward WHERE condition work?

where mid = 'M12341234';

[Dogo23]

Good question, it's because there are other ID's from that table that will need to be pulled as well. That's why I can't specify one unique ID in a where statement.