Filter Posts based on Labels, but still receive all Labels (inner join)

I have a posts table and a labels table. One post can have many labels.

In a query like this:

supabase.from("posts").select("*, labels(*)")

supabase.from("posts").select("*, labels(*)")

I receive all posts and all of their labels. Now, when I want to see posts with

label 1

label 1

, the query will look like this:

supabase.from("posts").select("*, labels!inner(*)").eq("labels.id", 1)

supabase.from("posts").select("*, labels!inner(*)").eq("labels.id", 1)

. But now I don't receive every label of each post anymore. I only get

label 1

label 1

, since the other labels don't pass the filter.

Is there a way to get every post, that has

label 1

label 1

while still receiving every other label?

Supabase•4y ago•

2 replies