مشکل در query

[beny]

با کوئری زیر مشکلم حل شد.

select father.*, name_c, age_c, name_w, age_w
from father
left join (select name_c, age_c,melicode_f from child order by age_c desc) as ch
on ch.melicode_f=father.melicode_f
left join (select name_w, age_w, melicode_f from woman order by age_w desc) as wm
on wm.melicode_f=father.melicode_f
group by father.id_f

ممنون