I have a table in a SQL database that stores the number of times a client is contacted.
It looks similar to this:
ID Date Status
1001 2014-05-01 Not Contacted
1001 2014-05-02 Not Contacted
1001 2014-05-04 Contacted
1005 2014-05-04 Not Contacted
1005 2014-05-05 Contacted
1007 2014-05-07 Not Contacted
1007 2014-05-08 Not Contacted
1009 2014-05-08 Not contacted
I want to select only those ID's that have not been contacted, so if you look at my example. ID 1001 has been attempted 3 times. but since t has been contacted, I want to exclude it. ID 1007 and 1009 have not been contacted so those are the only 2 I want to return. Any ideas on how to do this?
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Open in new window