Ken,
Fox does support this syntax. Let me see if I can find a recent example of this I've used...
Ahh.. Here's one..
DATE()-contacts.entered AS numdays;
FROM contacts, tasks;
WHERE contacts.custno = tasks.custno ;
AND contacts.inactive <> .T.;
AND EMPTY(contacts.company) <> .T. ;
AND contacts.custno NOT IN (SELECT DISTINCT custno FROM tasks WHERE "PROC F/U" $ tasks.tasktrak) ;
AND contacts.custno IN (SELECT DISTINCT custno FROM tasks WHERE "FILE2PREU" $ tasks.tasktrak);
ORDER BY contacts.entered, contacts.company
What you want is to think of this as kind of 'pre reducing' your pool of choices and then selecting from it.
Best,
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.