Eugene Elutin (12/10/2012)

---

Hope that following should help you:

SELECT tf.EmpNo, tf.ChkDate

FROM filesTA tf

WHERE tf.ChkDate BETWEEN '20121001' AND '20121005'

AND NOT EXISTS (SELECT 1 FROM SalaryDay2 sd2

...

Rookie thanks so much!!. it's Work 😀

Thanks you so much! Luis Cazares and SSC Rookie.It's work two solution. 😛

It's nice work 😀

Thank you very much SSChampion. 😀