Ciao tutti
Ho installato Mysql 5.1 e la query che funzionava perfettamente su MySql 3.5 ora non va piu.
Suggerimenti??
SELECT DATE(data_mov) as Data, data_mov as Data1 , count(id_movimento) as Numero FROM (
select * from (
(SELECT * FROM movimenti_cassa_backup WHERE data_mov >= '2010-04-01 00:00:00' AND data_mov < '2010-05-01 00:00:00' UNION select * FROM movimenti_cassa WHERE data_mov >= '2010-04-01 00:00:00' AND data_mov < '2010-05-01 00:00:00' ) as mall left join (
select * from movimenti_cassa_convenzioni where data_mov >= '2010-04-01 00:00:00' AND data_mov < '2010-05-01 00:00:00' ) as mconv on mall.id_movimento=mconv.id_movimento_cassa )
where id_movimento_convenzione is NULL ) occas_flt WHERE (esito = '0' OR esito = '7' or esito = '20' or esito= '100') GROUP BY Data ORDER BY Data;
l'errore è
Error Code : 1064
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 ') as mall left join (
select * from movimenti_cassa_convenzioni where data_mo' at line 3
Rispondi quotando
