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 这个返回的错误是说我的SQL语句哪里出错了?
php可以用substr
这个查询出来的是0000-00-00,格式是对,怎么没有取到值?
) ) , 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 这个返回的错误是说我的SQL语句哪里出错了?