konuya bakabildiniz mi aklınıza gelen bir yöntem var mı
Son Düzenleme: 03/02/2018, 14:43, Düzenleyen: mahsumyavuz.
(Sebep: bilgi istedim)
SELECT dbo_LG_031_CLCARD.CITY, dbo_LG_031_01_INVOICE.SPECODE, Sum(dbo_LG_031_01_INVOICE.NETTOTAL) AS ToplaNETTOTAL, CITY.HEDEF
FROM (dbo_LG_031_01_INVOICE INNER JOIN dbo_LG_031_CLCARD ON dbo_LG_031_01_INVOICE.CLIENTREF = dbo_LG_031_CLCARD.LOGICALREF) LEFT JOIN CITY ON dbo_LG_031_CLCARD.CITY = CITY.IL
GROUP BY dbo_LG_031_CLCARD.CITY, dbo_LG_031_01_INVOICE.SPECODE, CITY.HEDEF;