The third example provides the same result as when I check the files manually for the correct existance of the record (or not) and the correct values.

Thanks for looking at this!
Tracy

>Tracy:
>
>I haven't tried this, but what if you do this to the first query--see the new NOT added:
>
>

>SELECT cn_name, cn_port, cn_printer FROM lcontrol ;
>  WHERE !EMPTY(lcontrol.cn_name) .and. NOT (lcontrol.cn_name IN ;
>  (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .T.));
>  INTO TABLE (hdir+"tTEMPLCONTROL.DBF")
>

>
>Then applying DeMorgan's Theorem we get:
>
>

>SELECT cn_name, cn_port, cn_printer FROM lcontrol ;
>  WHERE !EMPTY(lcontrol.cn_name) .and. NOT lcontrol.cn_name IN ;
>  (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .F.);
>  INTO TABLE (hdir+"tTEMPLCONTROL.DBF")
>

>
>And does this make a difference?
>
>

>SELECT cn_name, cn_port, cn_printer FROM lcontrol ;
>  WHERE !EMPTY(lcontrol.cn_name) .and. lcontrol.cn_name NOT IN ;
>  (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .F.);
>  INTO TABLE (hdir+"tTEMPLCONTROL.DBF")
>

>
>It's worth a shot to try it and see what happens, because I'm curious too.
>
>HTH,
>
>--Paul