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.