Sorting & Joins

[Eric Katherman]

Is it possible to join documents and use a field from the "from" 
documents to sort the results?  For example, I need to search 
"employees" and sort on different fields of the "company" each employee 
is joined to.  What would that query look like?  We've looked at various 
resources but haven't found any concise examples that work.

Thanks,
Eric