Hola!

Perchè questa query in MySQL restituisce errore?:

codice:
strsql = "SELECT (select * login1 from tbl_login desc limit 10) as ultimo_reg," 
strsql = strsql & " (select * data_ricevuto from tbl_login desc limit 10) as UltimaData," 
strsql = strsql & "(select count(*) from tbl_login)as tot_utenti FROM tbl_login" 
rs2 = objconn.execute(strsql)
Tipo di errore:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-5.0.21-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'login1 from tbl_login desc limit 10) as ultimo_reg, (select * data_ricevuto from' at line 1

:master: