John,

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

>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