Cari Adres, Telefon, Mail Listesi
Logo Yazılım dan Sql Managent tarafından Cari Adres, Telefon, Mail Listesi için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT CODE AS Kod, DEFINITION_ AS Unvan, ADDR1 AS Adres1, ADDR2 AS Adres2, POSTCODE AS PostaKodu, DISTRICT AS Semt, TOWN AS ilce, CITY AS Sehir, COUNTRY AS Ulke, EMAILADDR As Email, TELNRS1 AS Tel1, TELNRS2 AS Tel2, FAXNR AS Faks, TAXNR AS Vergi_No, TAXOFFICE AS Vergi_Dairesi, ACTIVE AS Statusu FROM LG_001_CLCARD ORDER BY Unvan Asc |
Paylaş:
