Sergey,
here is the revised code that does work as I want. I have a cross reference table that matches employees with deductions using keys K_PREMPL and K_PRDEDEMP. I need to add new records where K_PREMPL+K_PRDEDEMP exist in the cursor c_PenDetail but do not exist in prdedemp.

* Add any missing deduction types for each employee.
TEXT TO mSqlCommand noshow pretext 15 TEXTMERGE
  insert into <<xfprdedemp>>
  (k_prempl, k_prdedmst)

  select k_prempl, k_prdedmst
  from c_PenDetail

  where transform(k_prdedmst,'9999999999')+ transform(k_prempl,'9999999999')
  not in (select transform(k_prdedmst,'9999999999')+ transform(k_prempl,'9999999999') from prdedemp)
ENDTEXT
&mSqlCommand

Is there a better way than using the transform to concatenate the fields?
Thanks,
John.

>John,
>
>It's not clear what you're trying to do and your query doesn't make any sense. Can you elaborate?