When creating a view, if you have a subquery in the select postgrest can't work out the relationships for the view any longer. Using joins with group by's will get around this.
When creating a view, if you have a subquery in the select postgrest can't work out the relationships for the view any longer. Using joins with group by's will get around this.