I apologize. Do not have a copy of VFP on this machine, working with Access 2007 for the moment. I assumed that they would be similar enough for this example. If not, then I will wait.

Made the change to the EXISTS () part as follows and nothing was returned.

SELECT 1 FROM Table1, Table2 WHERE Table1.Fld2 IS NULL and Table1.FldID = Table2.FldID

Stripped it down even further to the following and a single row was returned and FieldWithOne = 1
SELECT 1 as FieldWithOne FROM Table1 WHERE Table1.Fld2 IS NULL

What is the purpose of the SELECT 1? Does it have a special meaning in VFP?