select * 
from detallefactura 
where detallefactura.serial_caf in 
(select serial_caf from cabecerafactura where cabecerafactura.estado_caf='EMITIDA')