SQL

SELECT SUM(dbo.LG_XXX_01_INVOICE.GROSSTOTAL) FROM dbo.LG_XXX_01_INVOICE LEFT JOIN dbo.LG_XXX_CLCARD ON dbo.LG_XXX_01_INVOICE.CLIENTREF = dbo.LG_XXX_CLCARD.LOGICALREF LEFT JOIN dbo.L_CAPIDEPT ON dbo.LG_XXX_01_INVOICE.DEPARTMENT = dbo.L_CAPIDEPT.NR AND dbo.L_CAPIDEPT.FIRMNR