Пример

SELECT
 SUM(m.debit) as Debit, SUM(m.credit) as Credit
FROM gd_contact con
 JOIN gd_contact con1 ON con1.LB >= con.LB AND con1.RB <= con.RB
 JOIN inv_movement m ON con1.ID = m.contactkey
 LEFT JOIN gd_document doc ON m.documentkey = doc.ID
 LEFT JOIN inv_card c ON m.cardkey = c.ID
WHERE
 con.ID = 147146594
 AND m.movementdate >= '01.01.2006'
 AND m.movementdate <= '03.01.2007'
 AND c.goodkey = 148132903
 and doc.documenttypekey <> 147063932
 and (not doc.documenttypekey in (147596827, 147596870, 147596935, 148044102, 147017884))