> FROM helpdesk!llamadas ; > LEFT JOIN helpdesk!sub_unidades ON Llamadas.servicio = Sub_unidades.codigo; > LEFT JOIN helpdesk!ingeniero ON Llamadas.ingeniero = Ingeniero.codigo ; > LEFT JOIN helpdesk!dispositivo ON Llamadas.dispositivo = Dispositivo.codigo ; > LEFT JOIN helpdesk!oficina ON Llamadas.oficina = Oficina.codigo ; > LEFT JOIN helpdesk!usuarios_cia ON Llamadas.usuario = Usuarios_cia.codigo ; > GROUP BY Llamadas.numero >* ORDER BY Llamadas.numero && this is not necessary >ORDER BY not necessary? Perhaps you are right, but I am not sure. I may be wrong, but I think I read somewhere that there is no guarantee that the records will appear in any specific order. IOW, it might work in some cases, and not in others.