Order table by his relationship

I have a table with a relationship
Like Member -> Subscription (valid_until)

i want to order the table by the subscription.valid_until by default, so the admin can see which subscription will end sooner

Solution

Thats my first join, but seem like it works! thanks