把 distinct 移到 select后面:select distinct info.reg_Jgm,info.acct_Mgr,trans.tran_Code,trans.user_Id,sum(trans.tran_Amt),count(trans.tran_Code), info.user_Namefrom Fuser_Info as info,Ftrans_Info as trans where trans.tran_Code in ('6110','6120','3420','3320','3220') and trans.status=1 group by info.reg_Jgm,info.acct_Mgr,info.user...
|