Internal error

LET   VAR   : Syntax error (missing operator) in query expression 'tblSammetCategory.SCDisplayFROM tblSammetCategory INNER JOIN tblLanguage ON tblSammetCategory.SCCode = tblLanguage.SammetCatGROUP BY tblSammetCategory.SCDisplayORDER BY Count(tblLanguage.id) DESC'. 3075 0 DAO.Database at Engine RST  
 SQL is  SELECT Count(tblLanguage.id) AS CountOfid, tblSammetCategory.SCDisplayFROM tblSammetCategory INNER JOIN tblLanguage ON tblSammetCategory.SCCode = tblLanguage.SammetCatGROUP BY tblSammetCategory.SCDisplayORDER BY Count(tblLanguage.id) DESC;