COLLECTOR_Logo Collector Koşul işlemleri_SQL IN
<blockquote> <p>Farklı Sunucularda İç İçe Sorgu Kullanımı Örnek:</p> <p>SOURCE.LOGICALREF NOT IN (SELECT ORDFICHEREF FROM [COLLECTOR_SOURCE_DB].[GO3].[dbo].[LG_333_01_STLINE]) AND SOURCE.STATUS NOT IN (1,2)</p> <p><br /> Aynı Sunucuda İç İçe Sorgu Kullanım Örnek:</p> <p>SATINALMA FATURALARI<br /> SOURCE.CLIENTREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK')</p> <p>SATIŞ FATURALARI<br /> SOURCE.CLIENTREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK')</p> <p>İHRACAT OPERASYON FİŞLERİ (ihraç satış ve satınalmada denemedim ama çalışabilir)<br /> SOURCE.INVOICEREF IN(SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_01_INVOICE WHERE CLIENTREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK'))</p> <p>CARI HESAP FİŞLERİ<br /> SOURCE.CLCARDREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK')</p> <p>DEVİR ÇEKLERİ<br /> SOURCE.LOGICALREF IN(SELECT CSREF FROM [TigerEnterprise].[dbo].LG_002_01_CSTRANS WHERE CARDREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK'))</p> <p>CEK SENET BORDROLARI<br /> SOURCE.CARDREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK')</p> <p>BANKA FİŞLERİ<br /> SOURCE.LOGICALREF IN(SELECT SOURCEFREF FROM [TigerEnterprise].[dbo].LG_002_01_BNFLINE WHERE CLIENTREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK'))</p> <p>KASA İŞLEMLERİ<br /> SOURCE.LOGICALREF IN(SELECT SOURCEFREF FROM [TigerEnterprise].[dbo].LG_002_01_CLFLINE WHERE MODULENR=10 AND CLIENTREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD WHERE SPECODE3='PRK'))</p> </blockquote>
.JPG)
