- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
which one do you need to pick from communication_nm as i see those are two different values?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Try PROC SORT with the NODUPKEY option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What do you mean by 2 combinations?
Why doesn't a straightforward WHERE condition work?
where mid = 'M12341234';
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.