Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Question How To?
Message
De
03/02/2006 14:04:04
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Question How To?
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01093476
Message ID:
01093476
Vues:
67
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
Fil
Voir

Click here to load this message in the networking platform