select employeeId,sum(sale2005) as sale2005,sum(sale2006) as sale2006 from ( (select employeeId,sale as sale2005,nullas sale2006 from sale where years=2005) union (select employeeId,nullas sale2005,sale as sale2006 from sale where years=2006) ) tmp groupby employeeId