select U_ID,
sum(case when type = 1 then 1 else 0 end),//普通邮件
sum(case when type = 2 then 1 else 0 end),//语音邮件
sum(case when type = 3 then 1 else 0 end),//视频邮件
sum(case when new_check = 0 then 1 else 0 end),//新邮件
sum(case when new_checl = 1 then 1 else 0 end)//已查看邮件
from MeMber
group by U_ID
ljth1=dw_sgd1.getitemSTRING(DW_sgd1.GETrow(),"ljth")
select cpxh into :cpth3 from ljgdk where ljth=:ljth1;
先得到数据窗口中的LJTH的值,然后根据这个LJTH查找CPXH的值,把CPXH的值放到:CPTH3这个变量。
明白了吗?