 
create proc sp_StokKarti_Detay_Kontrolu
as
select * from STOKHAR s where StokKodu  not  in (select Kodu  from STOKKARTI )
select * from SIPARISHAR s where StokKodu  not  in (select Kodu  from STOKKARTI )
select * from StokBarkodlari s where StokKodu  not  in (select Kodu  from STOKKARTI )
select * from PDegFiyatlar s where StokKodu  not  in (select Kodu  from STOKKARTI )
select * from SipHar s where StokKodu  not  in (select Kodu  from STOKKARTI )
select * from TEKLIFHAR s where StokKodu  not  in (select Kodu  from STOKKARTI )
select * from Tevkifat s where Kod   not  in (select Kodu  from STOKKARTI )
select * from StokHarLog s where StokKodu  not  in (select Kodu  from STOKKARTI )
select * from Buton s where ButonDegeri  not  in (select Kodu  from STOKKARTI )
select * from StokFiyat  s where Kodu  not  in (select Kodu  from STOKKARTI )
select * from StokDB  s where StokKodu  not  in (select Kodu  from STOKKARTI )
---select * from MuadilStoklar  s where Kodu  not  in (select Kodu  from STOKKARTI )
