For simple explanation....
I have two tables with these fields:
MASTER
cname = char
DETAIL
cname = char (match above cname)
dorder = date
I need to create a list of all the MASTER records that DO NOT have a matching record in the detail.
I believe this should be a simple SQL select but I can't figure out how to get the joins / where clause
to work right so that I only get the MASTER records.
HELP!!! Something simple and it's driving me nuts!!!
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!