select cast(yhzh as char(20))+cast(object_name as char(10))+cast(gh as char(10))+cast(1 as char(10))+cast(idcard_num as char(20))+cast(sum(btje) as char(16))+' ' from T1,T2,T3 where T1.id=T2.btdx_uid and T1.id=T3.btdx_uid and lxdm in ('01','02','03','04') group by yhzh ,object_name,gh,idcard_num
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货