I have a fees table, that has an ‘office_id’ column - obviously this is just an int field. I want to order the fees results query based on the FK that office_id references in the ‘office’ table - obviously alphabetically.
Can I do this within the query where I am doing “->orderBy(‘office_id’)” obviously that ID is irrelevant, I need it to order by the FK ‘office_name’ in the office table - or do I need to process and order the results after the query returns ?
Thx