SELECT BDM_UserID, CRM_CustomerRegisterDate,MIN(DATE_FORMAT(BDM_ListenStartTime,"%Y_%m_%d")),MIN(DATE_FORMAT(BDM_ListenEndTime,"%Y_%m_%d")),SUM(BDM_ListenTimeLength)
FROM ETCRM.CRM_CustomerInfo o INNER JOIN ETBDM.BDM_UserInfo p ON o.BDM_UserName=p.BDM_UserName
INNER JOIN ETBDM.BDM_UserListenRec q ON p.BDM_UIID =q.BDM_UserID
WHERE (CRM_CustomerRegisterDate >='2013-01-01' AND CRM_CustomerRegisterDate<'2014-01-01') AND (BDM_ListenStartTime>='2013-01-01' AND BDM_ListenStartTime<'2014-01-01')
AND BDM_UserID !='' AND BDM_UserID='9741708'
GROUP BY BDM_UserID,MIN(DATE_FORMAT(BDM_ListenStartTime,"%Y_%m_%d"))
结果显示“Invalid use of group function”,不知道问题出在哪