凤
凤冠坡
Unregistered / Unconfirmed
GUEST, unregistred user!
楼主,下面的语句已经通过,说明你的问题也应该通过
query1.sql.Text := 下面的东西
SELECT 主叫, SUM(case 时间 when 10 then 100 else 200 end) As EAmount,
SUM(case 时间 when 120 then 400 else 500 end) AS IAmount
into Temp00
From DFPhone
where 文件='20010209.mix'
GROUP BY 主叫
Query1.ExecuteSQL;
query1.sql.Text := 下面的东西
SELECT 主叫, SUM(case 时间 when 10 then 100 else 200 end) As EAmount,
SUM(case 时间 when 120 then 400 else 500 end) AS IAmount
into Temp00
From DFPhone
where 文件='20010209.mix'
GROUP BY 主叫
Query1.ExecuteSQL;