Ciao.

Cosa c'è di sbagliato in questa query ASP eseguita su un DB ACCESS?

codice:
SQL = " SELECT "
SQL = SQL & " ENTE, "
SQL = SQL & " COUNT(ENTE) AS strENTE "
SQL = SQL & " (SELECT COUNT(ESITO) "
SQL = SQL & " FROM tabella WHERE ESITO = 'A' AND DATA = #2008/03/31#) AS A, "
SQL = SQL & " (SELECT COUNT(ESITO) "
SQL = SQL & " FROM tabella WHERE ESITO = 'B' AND DATA = #2008/03/31#) AS B, "
SQL = SQL & " (SELECT COUNT(ESITO) "
SQL = SQL & " FROM tabella WHERE ESITO = 'C' AND DATA = #2008/03/31#) AS C, "
SQL = SQL & " (SELECT COUNT(ESITO) "
SQL = SQL & " FROM tabella WHERE ESITO = 'D' AND DATA = #2008/03/31#) AS D, "
SQL = SQL & " (SELECT COUNT(ESITO) "
SQL = SQL & " FROM tabella WHERE ESITO = 'E' AND DATA = #2008/03/31#) AS E "
SQL = SQL & " FROM tabella "
SQL = SQL & " GROUP BY "
SQL = SQL & " ENTE "
SQL = SQL & " ORDER BY "
SQL = SQL & " ENTE ASC "
Perchè risponde con:

Microsoft JET Database Engine error '80040e14'

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

Grazie.