7,714
社区成员
发帖
与我相关
我的任务
分享
update Hz_ReportedResult set rr_ResultScore=(select avg(rrs_RateScore) from Hz_RateResultScore where rrs_IndexID=rr_IndexID and rr_UserID=rrs_ReportUserID ) where rr_IndexID in(select in_ID from Hz_Index where in_RateType=1)
update Hz_ReportedResult
set rr_ResultScore=davg('rrs_RateScore','Hz_RateResultScore','rrs_IndexID=' & rr_IndexID & ' and rrs_ReportUserID="' &rr_UserID & '"' )
where rr_IndexID in(select in_ID from Hz_Index where in_RateType=1)
update Hz_ReportedResult
set rr_ResultScore=davg('rrs_RateScore','Hz_RateResultScore','rrs_IndexID=' & rr_IndexID & ' and rrs_ReportUserID=' &rr_UserID )
where rr_IndexID in(select in_ID from Hz_Index where in_RateType=1)
update Hz_ReportedResult
set rr_ResultScore=davg('rrs_RateScore','Hz_RateResultScore','rrs_IndexID=' & rrs_IndexID & ' and rr_UserID=' & rrs_ReportUserID)
where rr_IndexID in(select in_ID from Hz_Index where in_RateType=1)