21,886
社区成员
发帖
与我相关
我的任务
分享
SELECT fStaff, count( DISTINCT (
intParent
) ) , count( chrDomain )
FROM G_register AS g, Users AS u
WHERE g.intParent = u.IDUser
AND fStaff IS NOT NULL
AND EPPStatus IS NOT NULL
AND fStaff <>0
AND (
TO_DAYS( DATE_FORMAT( dtCreate, '%Y-%c-%e' ) ) - TO_DAYS( '2000-10-30' )
) >=0
AND (
TO_DAYS( DATE_FORMAT( dtCreate, '%Y-%c-%e' ) ) - TO_DAYS( '2008-1-1' )
) <=0
GROUP BY fStaff
LIMIT 0 , 30
MySQL 返回:
#1052 - Column 'dtCreate' in where clause is ambiguous