Hi,
I want
select
item detials(date and qty) sum(qty)
'a01', '2007.01.01: 10/2007.02.03: 10', 20
'a02', ' 2007.01.10: 20/2007.02.12: 30', 50
'a03', ' 2007.01.18: 20', 20
from
table2
date, item, qty
2007.01.01, 'a01', 10
2007.01.10, 'a02', 20
2007.01.18, 'a03, 20
2007.02.03, 'a01', 10
2007.02.12, 'a02', 30
group by item
Thanks !
Shuming Wang
