1
SELECT tabla.parent_id, sum(debit) AS debit, sum(credit) AS credit
4
SELECT parent.id AS parent_id, node.id AS id,node.name
5
FROM res_partner AS node,res_partner AS parent
6
WHERE node.parent_left BETWEEN parent.parent_left AND parent.parent_right
7
ORDER BY parent.parent_left
10
(SELECT * FROM account_move_line)tabla2
11
ON tabla.id = tabla2.partner_id
12
GROUP BY tabla.parent_id