Perakende Satışlar
SELECT SUM(LG_086_01_INVOICE.NETTOTAL) AS [TOPLAM Ciro], LG_086_01_INVOICE.DATE_, LG_086_CLCARD.CODE, LG_086_CLCARD.DEFINITION_
FROM LG_086_01_INVOICE INNER JOIN
LG_086_CLCARD ON LG_086_01_INVOICE.CLIENTREF = LG_086_CLCARD.LOGICALREF
WHERE (LG_086_01_INVOICE.CANCELLED = 0)
GROUP BY LG_086_01_INVOICE.TRCODE, LG_086_01_INVOICE.DATE_, LG_086_CLCARD.CODE, LG_086_CLCARD.DEFINITION_
HAVING (LG_086_01_INVOICE.TRCODE = 7) AND (LG_086_01_INVOICE.DATE_ BETWEEN CONVERT(DATETIME, '2007-12-01 00:00:00', 102) AND
CONVERT(DATETIME, '2007-12-01 00:00:00', 102))
ORDER BY LG_086_01_INVOICE.DATE_
===============================================================================
Satışlardan İADELER
SELECT SUM(LG_086_01_INVOICE.NETTOTAL) AS [TOPLAM Ciro], LG_086_01_INVOICE.DATE_, LG_086_CLCARD.CODE, LG_086_CLCARD.DEFINITION_
FROM LG_086_01_INVOICE INNER JOIN
LG_086_CLCARD ON LG_086_01_INVOICE.CLIENTREF = LG_086_CLCARD.LOGICALREF
WHERE (LG_086_01_INVOICE.CANCELLED = 0)
GROUP BY LG_086_01_INVOICE.TRCODE, LG_086_01_INVOICE.DATE_, LG_086_CLCARD.CODE, LG_086_CLCARD.DEFINITION_
HAVING (LG_086_01_INVOICE.TRCODE = 3) AND (LG_086_01_INVOICE.DATE_ BETWEEN CONVERT(DATETIME, '2007-12-01 00:00:00', 102) AND
CONVERT(DATETIME, '2007-12-01 00:00:00', 102))
ORDER BY LG_086_01_INVOICE.DATE_
==============================================================================
Buraya kadar SQL den yardım alıyorum...
iki alanı EXCEL de çıkarıyorum...Yalnız senin yapmak istediğinde CH listesini de çekip DÜŞEYARA (VLOOKUP) fonksiyonunu kullanmak gerekebilir...