求救,,select检索的问题
我想从LIST表中统计 同一个用户 几条电话 各种金额的和,
前提是j193时长+j1791时长+j1792时长+j1793时长+j1795时长)<0.6*电信时长
下面是我写的SQL,但是DAVG只能有一个FIELDS,所以不能执行,谁能帮忙???
set outrs2=myconn.Execute( "select 用户名称,sum(电信金额) as usum,sum(移话金额) as ysum,sum(优惠金额) as hsum,sum(电信时长) as timetel,sum(j193时长) as time193,sum(j1791时长) as time1791,sum(j1792时长) as time1792,sum(j1793时长) as time1793,sum(j1795时长) as time1795 from LIST group by 用户名称 Having DAVG(j193时长+j1791时长+j1792时长+j1793时长+j1795时长)<0.6*电信时长")
前提解释: (j193时长+j1791时长+j1792时长+j1793时长+j1795时长)<0.6*电信时长 是指如果那条电话j193时长+j1791时长+j1792时长+j1793时长+j1795时长大于0.6*电信时长就忽略不计.