求教一个SQL语句,该怎么处理

求教一个SQL语句
T1
项目名称       项目规格        单位                天数    天次数
水                          1               杯                      2           3
烟                         1               包                      3             2
酒                         1                瓶                     1             1

结果
项目名称       项目规格        单位                天数    天次数      总次数
水                          1               杯                      1           1              1
水                          1               杯                      1           2             2
水                          1               杯                      1           3            3
水                          1               杯                      1           3            4
水                          1               杯                      2          1             5
水                          1               杯                      2          2            6
水                          1               杯                      2         3            7
水                          1               杯                      3         1            8
水                          1               杯                      3        2             9