求救“FROM 子句语法错误!” 这是什么问题
CString DateTimeend(m_Yearend+"-"+m_Monthend+"-"+m_Dayend+" "+m_Hourend);
CString DateTimebeg(m_Yearbeg+"-"+m_Monthbeg+"-"+m_Daybeg+" "+m_Hourbeg);
CString strSQL(_T(" select count(*) as '车辆总数',avg([CAR_SPEED]) as '车辆平均速度' ,count([OVER_SPEED] as '超速车辆总数' "
"FROM PLATE where COME_DATETIME between DateTimebeg and DateTimeend "));
m_pSet= new CRecordSetPlate;
m_pSet->GetDefaultConnect();
m_pSet->Open(CRecordset::snapshot,strSQL);
m_pSet->GetFieldValue(_T("车辆总数"),m_Passnub);
m_pSet->GetFieldValue(_T("车辆平均速度"),m_Speedavg);
m_pSet->GetFieldValue(_T("超速车辆总数"),m_Speednub);