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