[code]SELECT t0.googsB_id,
t1.NAME,
t1.code,
SUM(t0.num),
nvl(SUM(decode((SELECT substr(s.code,
0,
3)
FROM goodsA_type s
WHERE s.id =
t0.goodsA_type_id),
'aaa',
1,
'bbb',
-1) * t0.num * t0.price),
0) money
FROM goodsA t0,
goddsB t1
WHERE t0.goodB_id = t1.id AND
t0.accountant_date <=
To_date('2007-9-2',
'yyyy-mm-dd')
GROUP BY t0.goodB_id,
t1.NAME,
t1.code[/code]
t1.NAME,
t1.code,
SUM(t0.num),
nvl(SUM(decode((SELECT substr(s.code,
0,
3)
FROM goodsA_type s
WHERE s.id =
t0.goodsA_type_id),
'aaa',
1,
'bbb',
-1) * t0.num * t0.price),
0) money
FROM goodsA t0,
goddsB t1
WHERE t0.goodB_id = t1.id AND
t0.accountant_date <=
To_date('2007-9-2',
'yyyy-mm-dd')
GROUP BY t0.goodB_id,
t1.NAME,
t1.code[/code]