Problema ordenación left join

[huesos52]

la consulta te ordena por un campo resultante en la información a mostrar y no por uno que haga parte de una tabla generada a través de una consulta sin ser parte de los campos a mostrar.

Prueba algo así

select distinct ECT_D_Tarea.ect_id_tarea, ECT_D_Tarea.ect_ds_nombre as tarea,ECT_P_Estados.ect_ds_nombre as estado, ECT_P_Prioridades.ect_ds_nombre as prioridad, Contact_.firstname||' '||Contact_.middlename||' '||Contact_.lastname as creador, ECT_D_Tarea.ect_fh_fechacreacion as ect_fh_fechacreacion,ECT_D_Tarea.ect_fh_fechaultca mbio as ect_fh_fechaultcambio, ECT_D_Tarea.ect_fh_fechalimite as ect_fh_fechalimite, ECT_D_Tarea.ect_fh_fechaplanificada as ect_fh_fechaplanificada, tarusu.vinculado as vinculado
from ECT_P_Prioridades, User_, Contact_, ECT_D_Tarea LEFT JOIN
(select ECT_R_Tareas_Usuarios.ect_tarea_fk, ECT_R_Tareas_Usuarios.ect_usuario_FK, ECT_R_Tareas_Usuarios.ect_lg_vinculacion, Contact_.FIRSTNAME||' '||Contact_.MIDDLENAME||' '||Contact_.LASTNAME as vinculado
from ECT_R_Tareas_Usuarios, User_, Contact_
where Contact_.contactid = User_.userid and User_.userid= ECT_R_Tareas_Usuarios.ect_usuario_fk
) tarusu
on ECT_D_Tarea.ect_id_tarea=tarusu.ect_tarea_fk, ECT_P_Estados
where ECT_P_Estados.ect_id_estado = ECT_D_Tarea.ect_estado_fk and Contact_.contactid = User_.userid and User_.userid= ECT_D_Tarea.ect_creador_fk and ECT_D_Tarea.ect_prioridad_fk=ECT_P_Prioridades.ect _id_prioridad
order by vinculado

prueba y nos cuentas