CREATE VIEW dbo.CariList
AS
SELECT        CODE AS MKod, DEFINITION_ AS MAciklama, TAXNR AS VergiNo, TCKNO AS TCNo, TAXOFFICE AS VergDairesi, ADDR1 AS Adres1, ADDR2 AS Adres2, 
                         CITY AS Il, TOWN AS Ilce, TELNRS1 AS Telefon1, TELNRS2 AS Telefon2, EMAILADDR AS Mail, SPECODE2 AS OzelKod2
FROM            dbo.LG_011_CLCARD
WHERE        (ACTIVE = 0)