We had a requirement where we wanted our resultset to be sorted based on the associated link entity’s attribute.
This is how we need to write our fetch xml query.
Suppose we want to get all the Accounts records and its owner information sorted based on Owner’s Job Title. (Descending)
For this our Fetch XML query be something like this