SELECT ISLEMNO,COUNT(ISLEMNO) AS CIFTKAYITLAR FROM ACARI GROUP BY ISLEMNO HAVING ( COUNT(ISLEMNO) > 1 ) --STOKKARTLARI ÇİFT KAYIT KONTROLÜ- SELECT Kodu,COUNT(Kodu) AS CIFTKAYITLAR FROM STOKKARTI GROUP BY Kodu HAVING ( COUNT(Kodu) > 1 ) SELECT Kodu,COUNT(Kodu) AS CIFTKAYITLAR FROM StokFiyat GROUP BY Kodu HAVING ( COUNT(Kodu) > 1 ) SELECT Barkodu,COUNT(Barkodu) AS CIFTKAYITLAR FROM STOKKARTI GROUP BY Barkodu HAVING ( COUNT(Barkodu) > 1 ) CARİ KARTLAR ÇİFT KAYIT KOTROLU select MUSKOD FROM AMUSTERI GROUP BY MUSKOD HAVING ( COUNT (MUSKOD) >1)