<blockquote> <p>Farklı Sunucularda İç İçe Sorgu Kullanımı Örnek:</p> <p>SOURCE.LOGICALREF NOT IN (SELECT ORDFICHEREF FROM &nbsp;[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 &nbsp;WHERE SPECODE3=&#39;PRK&#39;)</p> <p>SATIŞ FATURALARI<br /> SOURCE.CLIENTREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD &nbsp;WHERE SPECODE3=&#39;PRK&#39;)</p> <p>İHRACAT OPERASYON FİŞLERİ (ihraç satış ve satınalmada denemedim ama çalışabilir)<br /> SOURCE.INVOICEREF &nbsp;IN(SELECT LOGICALREF &nbsp;FROM [TigerEnterprise].[dbo].LG_002_01_INVOICE WHERE CLIENTREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD &nbsp;WHERE SPECODE3=&#39;PRK&#39;))</p> <p>CARI HESAP FİŞLERİ<br /> SOURCE.CLCARDREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD &nbsp;WHERE SPECODE3=&#39;PRK&#39;)</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 &nbsp;WHERE SPECODE3=&#39;PRK&#39;))</p> <p>CEK SENET BORDROLARI<br /> SOURCE.CARDREF IN (SELECT LOGICALREF FROM [TigerEnterprise].[dbo].LG_002_CLCARD &nbsp;WHERE SPECODE3=&#39;PRK&#39;)</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 &nbsp;WHERE SPECODE3=&#39;PRK&#39;))</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 &nbsp;WHERE SPECODE3=&#39;PRK&#39;))</p> </blockquote>