>
> 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
>
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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
