复杂查询用例

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