Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Question How To?
Versions des environnements
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!!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement