General information
Category:
Coding, syntax & commands
Title:
SQL Question How To?
Environment versions
Network:
Windows 2003 Server
I have a customer that would like a report to list all donors that have not contributed for a specific date range. The donors are stored in a table called "Donors" and the contributions in a table called "Contributions". The "Donors" table has a unique identifier of cId. The "Contributions" table contains a cDonors_id foreign key. I have been able to create a SQL statement that returns all of the donors that have contributed for a specific date range. How can I do the opposite and return only the donors with no contributions for a specific date range?
Thanks In Advance!!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only