Any time.

>once again, many thanks for taking the time to give such detailed help.
>>
>>You don't have to concatenate fields. The second one should be faster.
>>

>>select k_prempl, k_prdedmst
>>	from c_PenDetail pd
>>	WHERE NOT EXISTS ( SELECT * FROM prdedemp
>>		WHERE k_prdedmst = pd.k_prdedmst AND k_prempl = pd.k_prempl)
>>
>>* or
>>select pd.k_prempl, pd.k_prdedmst
>>	from c_PenDetail pd
>>	LEFT JOIN prdedemp pr ON pr.k_prdedmst = pd.k_prdedmst AND pr.k_prempl = pd.k_prempl
>>	WHERE pr.k_prdedmst IS NULL
>>
>>