problema count tablas diferentes misma query

[quimfv]

Ya tengo el error, es el alias iataCompanyCode as company en el union ...

Código MySQL:

SELECT c.company, 
sum(c.numArrivals) as Arrivals, 
sum(c.numDep) as Departures 
FROM (SELECT DISTINCT a.iataCompanyCode as company, 
                                       count(a.idArrivalFlight) as numArrivals, 
                                       0 as numDep 
                       FROM `aodb`.`arrivalFlight` a 
                       WHERE a.iataCompanyCode IN ('SPP','IB') 
                       AND a.scheduledTime BETWEEN '2011-01-01 00:00:00' 
                                  AND '2011-09-01 00:00:00' 
                       GROUP BY a.iataCompanyCode,0
UNION all 
           SELECT DISTINCT b.iataCompanyCode as company, 
                                       0 as numArrivals, 
                                       count(b.idDepartureFlight) as numDep 
             FROM `aodb`.`departureflight` b 
             WHERE b.iataCompanyCode IN ('SPP','IB') 
             AND b.scheduledTime BETWEEN '2011-01-01 00:00:00' 
                  AND '2011-09-01 00:00:00' 
             GROUP BY b.iataCompanyCode,0) as c 
GROUP BY c.company;
 

O lo quitas o como te he puesto lo usas en el ultimo group by

SELECT c.company,
sum(c.numArrivals) as Arrivals,
sum(c.numDep) as Departures
FROM (

) as c
GROUP BY c.company;

Quita los alias en el union no son necesarios...