Hi,
It's hard for me to think of an appropriate title to give this post, otherwise I would provide one more descriptive. So sorry for that.
I have data in a table like this:
USER ID
smith_john_email 111222
smith_john_pager 111222
doe_jane_pager 222333
And so forth. Some ID's have a record entry ending in "_email". I need to get a listing of all distinct ID's which do not have an entry like that. I'm not sure how to do this.
Would greatly appreciate your help. Thank you.