56259989261070007440762013-04-14T09:56:25.02762013-08-07T12:02:04.92000falsefalse56259989261070007440762013-04-14T09:56:25.02762013-08-07T12:02:04.92000Moidfiyfalse业务员新增客户对比图select COUNT(a.Id) 合计数量,isnull(b.UserENName,'其它') UserENName from t_bse_Client a left join t_bse_user b on a.CreatedId=b.Id group by b.UserENNamefalse<ArrayOfWhereObj xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />select COUNT(a.Id) 合计数量,isnull(b.UserENName,'其它') UserENName from t_bse_Client a left join t_bse_user b on a.CreatedId=b.Id group by b.UserENName4UserENName合计数量608