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
2 Replies
I guess you need a join on that table
Solution![No description](https://answer-overflow-discord-attachments.s3.amazonaws.com/1174881536722620496/Screenshot_2023-11-16_at_6.19.38_p.m..png)
Thats my first join, but seem like it works! thanks
![No description](https://answer-overflow-discord-attachments.s3.amazonaws.com/1174881536722620496/Screenshot_2023-11-16_at_6.19.38_p.m..png)