BordroPlus için sorgu, rapor, eklenti paylaşımını burada yapabiliriz.
************
select
YEAR(P.PERDBEG) YIL
,MONTH(P.PERDBEG) AY
,D.NAME ISYERI
,S.CODE KODU
,S.NAME ADI
,S.SURNAME SOYADI
,INF.IDTCNO TCKNO
,CASE S.yasak WHEN 1 THEN 'ERKEK' ELSE 'KADIN' END CINSIYET
,CASE S.TYP WHEN 1 THEN 'AKTIF' ELSE 'PASIF' END STATU
,CASE LAW.SSKSTATUS WHEN 1 THEN 'Normal'WHEN 2 THEN 'Emekli'WHEN 3 THEN 'Çirak'WHEN 4 THEN 'Stajyer'WHEN 5 THEN 'Yabanci' WHEN 6 THEN 'Bag-kur(çalisan)'WHEN 7THEN 'Bag-kur(emekli)' WHEN 8 THEN 'Diger'else 'Tanimsiz' end as 'SGK STATU'
,CONVERT(VARCHAR(10),S.INDATE, 104) 'GIRIS TARIHI'
,CONVERT(VARCHAR(10),S.BIRTHDATE, 104) 'DOGUM TARIHI'
,(SELECT EXP FROM LH_001_TYPEDEF WHERE TYP=-44 AND NR=S.JOBREF) 'MESLEK KODU'
,(SELECT DESC_ FROM LH_001_TYPEDEF WHERE TYP=-44 AND NR=S.JOBREF) 'MESLEK ADI'
,(SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=0 AND NR=1 AND PREF=P.LREF) 'SGK GUN'
---,(SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=0 AND NR=2 AND PREF=P.LREF) 'VERGI GUN'
,(SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=0 AND NR=3 AND PREF=P.LREF) 'CALISMA GUN'
,P.WAGE_WAGE UCRETI
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=1 AND PREF=P.LREF),0) 'Gün Normal'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=2 AND PREF=P.LREF),0) 'Gün Hafta Tatili'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=3 AND PREF=P.LREF),0) 'Gün Resmi Tatil'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=4 AND PREF=P.LREF),0) 'Gün Ücretli İzin'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=5 AND PREF=P.LREF),0) 'Gün Çalışılan Tatil'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=6 AND PREF=P.LREF),0) 'Gün Ücretsiz İzin'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=7 AND PREF=P.LREF),0) 'Gün Yıllık İzin'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=8 AND PREF=P.LREF),0) 'Gün Doğum İzni'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=9 AND PREF=P.LREF),0) 'Gün Ölüm İzni'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=10 AND PREF=P.LREF),0) 'Gün Mazeretsiz İzin '
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=11 AND PREF=P.LREF),0) 'Gün Mazeret İzni'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=12 AND PREF=P.LREF),0) 'Gün Evlilik İzni'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=13 AND PREF=P.LREF),0) 'Gün Mazeret İzni2'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=14 AND PREF=P.LREF),0) 'Gün Mazeretsiz İzin2'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=15 AND PREF=P.LREF),0) 'Gün Raporlu'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=16 AND PREF=P.LREF),0) 'Gün Raporlu2'
, COALESCE((SELECT DAY_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=17 AND PREF=P.LREF),0) 'Gün Ücretli Rapor'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=1 AND PREF=P.LREF),0) 'Brüt Normal'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=2 AND PREF=P.LREF),0) 'Brüt Hafta Tatili'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=3 AND PREF=P.LREF),0) 'Brüt Resmi Tatil'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=4 AND PREF=P.LREF),0) 'Brüt Ücretli İzin'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=5 AND PREF=P.LREF),0) 'Brüt Çalışılan Tatil'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=6 AND PREF=P.LREF),0) 'Brüt Ücretsiz İzin'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=7 AND PREF=P.LREF),0) 'Brüt Yıllık İzin'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=8 AND PREF=P.LREF),0) 'Brüt Doğum İzni'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=9 AND PREF=P.LREF),0) 'Brüt Ölüm İzni'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=10 AND PREF=P.LREF),0) 'Brüt Mazeretsiz İzin '
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=11 AND PREF=P.LREF),0) 'Brüt Mazeret İzni'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=12 AND PREF=P.LREF),0) 'Brüt Evlilik İzni'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=13 AND PREF=P.LREF),0) 'Brüt Mazeret İzni2'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=14 AND PREF=P.LREF),0) 'Brüt Mazeretsiz İzin2'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=15 AND PREF=P.LREF),0) 'Brüt Raporlu'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=16 AND PREF=P.LREF),0) 'Brüt Raporlu2'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=17 AND PREF=P.LREF),0) 'Brüt Ücretli Rapor'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=1 AND PREF=P.LREF),0) 'B1a '
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=2 AND PREF=P.LREF),0) 'B2b'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=0 AND PREF=P.LREF),0) 'B1 '
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=4 AND PREF=P.LREF),0) 'B4'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=6 AND PREF=P.LREF),0) 'B5'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=7 AND PREF=P.LREF),0) 'B6'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=41 AND PREF=P.LREF),0) 'B7'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=42 AND PREF=P.LREF),0) 'B8'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=61 AND PREF=P.LREF),0) 'B9'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=6 AND PREF=P.LREF),0) 'Baa5'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=7 AND PREF=P.LREF),0) 'Baa6'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=6 AND PREF=P.LREF),0) 'Ba5'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=7 AND PREF=P.LREF),0) 'Ba6'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=41 AND PREF=P.LREF),0) 'Ba7'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=42 AND PREF=P.LREF),0) 'Ba8'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=61 AND PREF=P.LREF),0) 'Ba9'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=6 AND PREF=P.LREF),0) 'Bb5'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=7 AND PREF=P.LREF),0) 'Bb6'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=41 AND PREF=P.LREF),0) 'Bb7'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=42 AND PREF=P.LREF),0) 'Bb8'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=61 AND PREF=P.LREF),0) 'Bb9'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=6 AND PREF=P.LREF),0) 'Bc5'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=7 AND PREF=P.LREF),0) 'Bc6'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=41 AND PREF=P.LREF),0) 'Bc7'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=42 AND PREF=P.LREF),0) 'Bc8'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=61 AND PREF=P.LREF),0) 'Bc9'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=6 AND PREF=P.LREF),0) 'Bd5'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=7 AND PREF=P.LREF),0) 'Bd6'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=41 AND PREF=P.LREF),0) 'Bd7'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=42 AND PREF=P.LREF),0) 'Bd8'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=6 AND NR=61 AND PREF=P.LREF),0) 'Bd9'
, COALESCE((SELECT HOUR_ FROM LH_001_PNTLINE WHERE TYP=2 AND NR=1 AND PREF=P.LREF),0) 'Saat Normal Mesai'
, COALESCE((SELECT HOUR_ FROM LH_001_PNTLINE WHERE TYP=2 AND NR=2 AND PREF=P.LREF),0) 'Saat Pazar Mesaisi'
, COALESCE((SELECT HOUR_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=3 AND PREF=P.LREF),0) 'Saat Resmi Tatil Mesaisi'
, COALESCE((SELECT HOUR_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=4 AND PREF=P.LREF),0) 'Saat Fazla Mesai (4)'
, COALESCE((SELECT HOUR_ FROM LH_001_PNTLINE WHERE TYP=1 AND NR=5 AND PREF=P.LREF),0) 'Saat Gece Vardiyası'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=2 AND NR=1 AND PREF=P.LREF),0) 'Brüt Normal Mesai'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=2 AND NR=2 AND PREF=P.LREF),0) 'Brüt Pazar Mesaisi'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=2 AND NR=3 AND PREF=P.LREF),0) 'Brüt Resmi Tatil Mesaisi'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=2 AND NR=4 AND PREF=P.LREF),0) 'Brüt Fazla Mesai (4)'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=2 AND NR=5 AND PREF=P.LREF),0) 'Brüt Gece Vardiyası'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=3 AND NR=1 AND PREF=P.LREF),0) 'S.Y. Yemek Yardımı'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=3 AND NR=2 AND PREF=P.LREF),0) 'S.Y. Ulaşım Yardımı'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=3 AND NR=3 AND PREF=P.LREF),0) 'S.Y. Aile Yardımı'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=3 AND NR=4 AND PREF=P.LREF),0) 'S.Y. Çocuk Yardımı'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=3 AND NR=5 AND PREF=P.LREF),0) 'S.Y. Şahıs Sigortası'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=3 AND NR=6 AND PREF=P.LREF),0) 'S.Y. Bireysel Emeklilik Sigortası'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=1 AND PREF=P.LREF),0) 'E.O. İkramiye'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=2 AND PREF=P.LREF),0) 'E.O. Kıdem Tazminatı'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=3 AND PREF=P.LREF),0) 'E.O. İhbar Tazminatı'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=4 AND PREF=P.LREF),0) 'E.O. Harcırah'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=5 AND PREF=P.LREF),0) 'E.O. Vergi İadesi'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=6 AND PREF=P.LREF),0) 'E.O. Nema Ödemesi'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=7 AND PREF=P.LREF),0) 'E.O. Yıllık İzin Ücreti'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=8 AND PREF=P.LREF),0) 'E.O. Prim'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=9 AND PREF=P.LREF),0) 'E.O. Kullanılmayan Yıllık izin'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=10 AND PREF=P.LREF),0) 'E.O. Ek Ödeme '
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=11 AND PREF=P.LREF),0) 'E.O. Fazla Mesai'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=4 AND NR=12 AND PREF=P.LREF),0) 'E.O. Pazar Mesaisi'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=1 AND PREF=P.LREF),0) 'E.K. Şahıs Sigortası'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=2 AND PREF=P.LREF),0) 'E.K. Bireysel Emeklilik Sigortası'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=3 AND PREF=P.LREF),0) 'E.K. Ek Kesinti-1'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=4 AND PREF=P.LREF),0) 'E.K. İhbar Tazminatı'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=8 AND PREF=P.LREF),0) 'E.K. Masraf'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=9 AND PREF=P.LREF),0) 'E.K. Yasal Kesintiler'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=10 AND PREF=P.LREF),0) 'E.K. İcra'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=11 AND PREF=P.LREF),0) 'E.K. Bes'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=12 AND PREF=P.LREF),0) 'E.K. Avans'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=13 AND PREF=P.LREF),0) 'E.K. Trafik Cezası '
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=14 AND PREF=P.LREF),0) 'E.K. Nafaka'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=15 AND PREF=P.LREF),0) 'E.K. İcra2'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=16 AND PREF=P.LREF),0) 'E.K. Trafik Cezası2'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=17 AND PREF=P.LREF),0) 'E.K. Avans2'
, COALESCE((SELECT GROSSAM FROM LH_001_PNTLINE WHERE TYP=1 AND NR=18 AND PREF=P.LREF),0) 'E.K. Nafaka2'
,BALN_PAYMENTS_PTD 'ÖDEMELER TOPLAMI'
,BALN_TAXNBASE_YTD 'VERGI MATRAHI'
,BALN_TAXNORM_YTD+BALN_MINWAGEDISC_PTD 'VERGİ KESINTISI TUTARI'
,BALN_MINWAGEDISC_PTD AGI
,BALN_STAMPBASE_PTD 'DAMGA MATRAHI'
,BALN_STAMP 'DAMGA VERGİSİ'
,BALN_SSKNBASE_PTD 'SGK MATRAH'
,BALN_SECEPLE_PTD 'SGK ISCI'
,BALN_SECEPLR_PTD 'SGK ISVEREN'
,BALN_SSKPRIMGOVDEPLAW 'SGK HAZINE PAYI'
,BALN_NETWAGE 'NET ODEME'
from LH_001_PNTCARD AS P
INNER JOIN LH_001_PERSON AS S ON S.LREF=P.PERREF
INNER JOIN L_CAPIDIV AS D ON D.NR=P.LOCNR
INNER JOIN LH_001_FAMILY FAM ON S.LREF = FAM.PERREF AND RELATION = 0
INNER JOIN LH_001_PERIDINF INF ON INF.LREF = FAM.IDREF
INNER JOIN LH_001_LAWCHG LAW ON S.LREF = LAW.PERREF AND LAW.ENDDATE IS NULL
*******************
select
(SELECT CODE FROM LH_001_PERSON WHERE LREF=F.PERREF) Kodu
,(SELECT name FROM LH_001_PERSON WHERE LREF=F.PERREF) Adı
,(SELECT SURNAME FROM LH_001_PERSON WHERE LREF=F.PERREF) Soyadı
,case RELATION WHEN 1 THEN 'Eşi' when 2 then 'Cocuk' when 3 then 'Anne' else 'Baba' end Yakınlık
,f.name Adi
,f.SURNAME Soyadi
,case yasak when 1 then 'Bay' else 'Bayan' end Cinsiyet
,case EDUCSTAT WHEN 0 then 'Tanımsız' when 1 then 'Evet' else 'Hayır' end OgrencilikDurumu
,case SUPPORTED when 0 then 'Evet' else 'Hayir' end BakmaklaYukumlu
,case MINWGDISCSTAT when 0 then 'Evet' else 'Hayir' end AgiDurumu
,(select BIRTHDATE from LH_001_PERIDINF WHERE LREF=F.IDREF) DogumTarihi
from LH_001_FAMILY AS F
where RELATION<>0
GO
******************
(SELECT name FROM LH_001_FAMILY WHERE LREF=F.CARDREF) Adı
,(SELECT SURNAME FROM LH_001_FAMILY WHERE LREF=F.CARDREF) Soyadı
,CASE HTYPE
WHEN 1 THEN 'Vizite'
WHEN 2 THEN 'Rapor'
WHEN 3 THEN 'Konrol'
WHEN 4 THEN 'Teshis'
WHEN 5 THEN 'Tetkik'
WHEN 6 THEN 'İşKazası'
WHEN 7 THEN 'MeslekHastalıgı' end Tip
,f.EVALDATE IslemTarihi
,f.PERIOD1 Baslangic
,f.PERIOD2 Bitiş
,f.OFFDAYS1 Sure
,f.exp1 + f.exp2 Acıklama
from
LH_001_HEALTH AS F
where (SELECT name FROM LH_001_FAMILY WHERE LREF=F.CARDREF)<>'x'
**********************