-- query para identificar
SELECT count(*) as total, rc.retorno
FROM d_reservas r 
JOIN d_reserva_confirmacoes rc ON rc.reserva_id=r.id 
WHERE r.status IN ('vendido')
group by rc.retorno
order by total desc;
-- query para corrigir
UPDATE
     d_reserva_confirmacoes rc
JOIN d_reservas r ON r.id=rc.reserva_id
    ,(
        SELECT
             ru.reserva_id
            ,MIN( i.de ) AS min 
            ,MAX( i.ate ) AS max
        FROM
            d_reserva_itens i
		JOIN d_reserva_usuarios ru on ru.id=i.reserva_usuario_id
        GROUP BY
            ru.reserva_id
    ) AS i
SET
     rc.ida = i.min
    ,rc.retorno = i.max
WHERE
    rc.reserva_id = i.reserva_id
	AND r.status IN ('vendido')
	AND rc.retorno='2014-08-28';