SELECT UnionX.Kayit_1_ID as Kimlik, Count(UnionX.Kayit_1_ID) AS Say
FROM (SELECT Tablo2.Kayit_1_ID
FROM Tablo2
union all
SELECT Tablo2.Kayit_2_ID
FROM Tablo2
union all
SELECT Tablo2.Kayit_3_ID
FROM Tablo2
union all
SELECT Tablo2.Kayit_4_ID
FROM Tablo2
union all
SELECT Tablo2.Kayit_5_ID
FROM Tablo2
union all
SELECT Tablo2.Kayit_6_ID
FROM Tablo2
union all
SELECT Tablo2.Kayit_7_ID
FROM Tablo2
union all
SELECT Tablo2.Kayit_8_ID
FROM Tablo2) AS UnionX
GROUP BY UnionX.Kayit_1_ID
HAVING (((UnionX.Kayit_1_ID) Is Not Null))
ORDER BY UnionX.Kayit_1_ID;
aşağıdaki kodu dener misiniz?