Ciao a tutti,
Perche non riesco a fare la group by tra le 2 UNION.

codice:
(
SELECT DATE(data) as Data , data as Data1 ,COUNT(*) as Numero FROM (  
SELECT date(t11.data) as Data   FROM soste_backup as s11 INNER JOIN transiti_backup as t11 ON (s11.id_transito_uscita=t11.id_transito) WHERE (t11.data >= '2010-08-01 00:00:00'  AND t11.data < '2010-09-01 00:00:00' )  AND (s11.tipo_utente = 'O') AND(s11.stato2=0 and s11.stato4=1) And  (DATE_ADD(s11.data_start_sosta, INTERVAL 1 * 25 MINUTE) >= t11.data )   
) s6 GROUP BY Data 
)
Union
(
SELECT DATE(data) as Data , data as Data1 ,COUNT(*) as Numero FROM (  
select date(tb.data) as Data from soste_backup as sb inner join  movimenti_cassa as m on m.id_movimento=sb.id_movimento_cassa
inner join  transiti_backup as tb on sb.id_transito_uscita=tb.id_transito
WHERE (tb.data >='2010-08-01 00:00:00' and tb.data <'2010-09-01 00:00:00')  and (sb.stato2=1 and sb.stato4=1) and (m.esito=5) and (sb.tipo_utente = 'O')  And (DATE_ADD(sb.data_start_sosta, INTERVAL 1 * 25 MINUTE) >= tb.data ) 
) s2 GROUP BY Data 
)
  order by Data