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

Reply via email to