>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!!!
sele * ;
from Master ;
where cname not in (sele dist cname from detail) ;
into cursor whatever
Rip Ryness
International Falls, MN