Pardon the newbie question, but alas I've become mired down in
what would seem a simple query.
I've recently started developing in VFP, and find it much more
attractive than my past efforts in 2.6
Anyhow here is my problem. ANY suggestions are most welcome!
I have two tables. One with names of all the people that have
ever donated money to our organization indexed on their id
number, and another of current donators in the last 6 months or
so, indexed on the id number as well.
What I need is a list of all those who are in the name list that
aren't in the current donator list. (Thus giving me a list of
all people who have NOT donated in the last six months.)
I tried what I thought logical, and did a query that in the join
statement queried fo names.id_no NOT equal to currentdon.id_no.
Well two hours and Two GIGS later the query could still not
finish when my drive ran out of room. (These databases are no
bigger than 2MB each)
I assume this is NOT the way to do it!
Any help for a lost soul is very welcome!
Thanks,
- Mike White