Page History

CREATE  VIEW  [dbo].[COVID_EKSIKGUN]

AS
SELECT
SICILAYOTR.ISYERI, 
SICILAYOTR.SICILNO,
SICILAYOTR.TCKIMLIK  AS  TC_NO, 
SICILAYOTR.ADI	AS  SIGORTALI_ADI, 
SICILAYOTR.SOYADI  AS  SIGORTALI_SOYADI, 
SICILAYOTR.YIL,
SICILAYOTR.AY, 
SICIZIN.ISGUNU+SICIZIN.HAFTATATILI  AS  GUN, 
SICIZIN.IZINNEDKOD,
BANKALISTE.IBAN_1	AS  IBAN, 
SICILEK.CEPTEL  AS  SIGORTALI_MOBILTEL 
FROM  SICILAYOTR
INNER  JOIN  SICIZIN  ON 
(SICILAYOTR.ISYERI=SICIZIN.ISYERI	AND 
SICILAYOTR.SICILNO=SICIZIN.SICILNO) 
LEFT  OUTER  JOIN  BANKALISTE  ON
(SICILAYOTR.ISYERI=BANKALISTE.ISYERI  AND 
SICILAYOTR.SICILNO=BANKALISTE.SICILNO)
LEFT  OUTER  JOIN  SICILEK  ON  (SICILAYOTR.ISYERI  = 
SICILEK.ISYERI  AND  SICILAYOTR.SICILNO  =  SICILEK.SICILNO  )

GO