SELECT
INVFC.FICHENO, INVFC.DATE_, INVFC.DEPARTMENT, INVFC.BRANCH, INVFC.SPECODE, INVFC.CYPHCODE, INVFC.DOCODE, INVFC.FACTORYNR, INVFC.TRADINGGRP, INVFC.REFLECTED, INVFC.TRCODE, INVFC.STATUS, INVFC.ESTATUS, INVFC.LOGICALREF, INVFC.CLIENTREF, INVFC.SOURCEINDEX, INVFC.TIME_, INVFC.TRCURR, INVFC.TRRATE, INVFC.REPORTRATE, INVFC.RECVREF, INVFC.CANCELLED, INVFC.DISTORDERREF, INVFC.GROSSTOTAL, INVFC.TOTALDISCOUNTS, INVFC.TOTALEXPENSES, INVFC.TOTALVAT, INVFC.NETTOTAL, INVFC.DECPRDIFF, INVFC.DEDUCTIONPART1, INVFC.DEDUCTIONPART2, CLNTC.DEFINITION_, CLNTC.CODE, CLNTC.SPECODE, CLNTC.SPECODE2, CLNTC.SPECODE3, CLNTC.SPECODE4, CLNTC.SPECODE5, CLNTC.ACTIVE, CLNTC.CYPHCODE, CLNTC.LOGICALREF, PAYPL.CODE, PAYPL.LOGICALREF, SLSMC.CODE, SLSMC.POSITION_, SLSMC.DEFINITION_, SLSMC.ACTIVE, PROJECT.CODE, PROJECT.NAME
FROM
LG_430_01_INVOICE INVFC WITH(NOLOCK) LEFT OUTER JOIN LG_430_CLCARD CLNTC WITH(NOLOCK) ON (INVFC.CLIENTREF = CLNTC.LOGICALREF) LEFT OUTER JOIN LG_430_PAYPLANS PAYPL WITH(NOLOCK) ON (INVFC.PAYDEFREF = PAYPL.LOGICALREF) LEFT OUTER JOIN "GK2"..LG_SLSMAN SLSMC WITH(NOLOCK) ON (INVFC.SALESMANREF = SLSMC.LOGICALREF) LEFT OUTER JOIN LG_430_PROJECT PROJECT WITH(NOLOCK) ON (INVFC.PROJECTREF = PROJECT.LOGICALREF)
WHERE
(INVFC.CANCELLED = 0) AND ((INVFC.DATE_ >= CONVERT(dateTime, '10-1-2014', 101)) AND (INVFC.DATE_ <= CONVERT(dateTime, '12-31-2014', 101))) AND (INVFC.TRCODE IN (
) AND (INVFC.STATUS IN (0,1)) AND (INVFC.DEPARTMENT IN (0)) AND (INVFC.BRANCH IN (0)) AND (INVFC.FACTORYNR IN (0)) AND (CLNTC.DEFINITION_ LIKE 'AKPINAR TİCARET OTO LASTİK ALIM SATIMI') AND (INVFC.DEVIR IN (0))
ORDER BY
INVFC.DATE_, INVFC.FICHENO, INVFC.DOCODE, INVFC.TIME_, INVFC.TRCODE
SELECT
STRNS.SOURCEINDEX, STRNS.DISCPER, STRNS.VAT, STRNS.OUTPUTIDCODE, STRNS.AMOUNT, STRNS.LOGICALREF, STRNS.STOCKREF, STRNS.INVOICELNNO, STRNS.LINETYPE, STRNS.TOTAL, STRNS.TRRATE, STRNS.REPORTRATE, STRNS.TRCURR, STRNS.VATAMNT, STRNS.VATINC, STRNS.VATMATRAH, STRNS.PRICE, STRNS.UOMREF, STRNS.GLOBTRANS, STRNS.ABVATSTATUS, STRNS.CANDEDUCT, STRNS.UNDERDEDUCTLIMIT, STRNS.DEDUCTIONPART1, STRNS.DEDUCTIONPART2, GLACC.CODE, GLACC.LOGICALREF, GLACC.DEFINITION_, SLSMC.LOGICALREF
FROM
LG_430_01_STLINE STRNS WITH(NOLOCK) LEFT OUTER JOIN LG_430_EMUHACC GLACC WITH(NOLOCK) ON (STRNS.ACCOUNTREF = GLACC.LOGICALREF) LEFT OUTER JOIN "GK2"..LG_SLSMAN SLSMC WITH(NOLOCK) ON (STRNS.SALESMANREF = SLSMC.LOGICALREF)
WHERE
(STRNS.INVOICEREF = 8024) AND (STRNS.DETLINE = 0) AND (STRNS.SOURCEINDEX IN (0,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56))
ORDER BY
STRNS.INVOICELNNO
aslında sorgu tam olarak bu üstteki fatura başlığı alttaki detay
ama sorun bunları tek sorgu olarak nasıl kullanabilirim.
