Is there a way to sort retrieve datas based on a variable of its child?

General
1

So i have 2 table which is Tennant and Brand

I would like to get datas of Tennants but sorted based on the name of the Brand, i tried using sort options “brand.brandName” but it returned an error

2

you can not sort by child records only by parent.