I have a cross reference table attaching the employee deduction types table to employees. I need a SQL insert to update this table. The code below crashes because you can't use IN (SELECT...) more than once in a query (I assume). Anyone want to take a crack at it?

* 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 prdedmst
  where prdedemp.k_prempl not in (select k_prempl from prdedmst)
  and prdedemp.k_prdedmst not in (select k_prdedmst from prdedmst)
ENDTEXT
&mSqlCommand