How about:

Select * From BigTable Where CandKey Not In (Select CandKey From SmallTable) Into Cursor TmpCursor

jcDBFName = DBF()

Select SmallTable
Append From (jcDBFName)

In my experience sometimes by issuing a SQL statement like that what you really get is a FILTER of Bigtable. In that case you'll be doing the APPEND from Bigtable and not from the CURSOR, so just to be safe my SQLs for this kind of situation look like

Select *, '' as cFld From Bigtable ......

just to force the creation of the CURSOR.

Iraldo.