Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Question How To?
Message
From
03/02/2006 14:04:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Question How To?
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01093476
Message ID:
01093476
Views:
68
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
Map
View

Click here to load this message in the networking platform