INSERT INTO izin ( iz, izta, izsr )
SELECT g_pervetarih.id, g_pervetarih.Tarihler, "0" AS bossure
FROM (SELECT Tablo1.id, Tablo1.Per_Ad, g_tarihler.Tarihler, [id] & "-" & Month([Tarihler]) & "-" & Year([Tarihler]) AS per_kriter
FROM Tablo1, (SELECT "01." & Format(Month(CDate("1 " & [Aylar])),"00") & "." & Year(Date()) AS Tarihler
FROM Aylar
GROUP BY "01." & Format(Month(CDate("1 " & [Aylar])),"00") & "." & Year(Date()), Month(CDate("1 " & [Aylar]))
HAVING (((Month(CDate("1 " & [Aylar])))<=Month(Date())))) AS g_tarihler) AS g_pervetarih LEFT JOIN Yap_Gereken ON g_pervetarih.[per_kriter] = Yap_Gereken.[per_kriter]
WHERE (((Yap_Gereken.per_kriter) Is Null));
Bu kod ile, nisan ayına girildiğinde 01.04.2018'i de ekler.
