Filter inner joins
Hey guys!
I have a select that looks like this:
But what I would like to do is to make an inner join filter on the products table.
I would like to get all subscriptions that dosen't match a specific product. Something like:
Is that possible?
I have a select that looks like this:
supabase
.from('subscriptions')
.select('*, prices(*, products(*))')
.in('status', ['trialing', 'active']);But what I would like to do is to make an inner join filter on the products table.
I would like to get all subscriptions that dosen't match a specific product. Something like:
supabase
.from('subscriptions')
.select('*, prices(*, products!inner(*))')
.neq('products.id', 'prod_MSjuJNMlVA1zBF')
.in('status', ['trialing', 'active']);Is that possible?
