# Filter with inner join in supabase

**URL:** <https://community.weweb.io/t/filter-with-inner-join-in-supabase/13752>\
**Category:** How do I?\
**Tags:** supabase\
**Created:** [October 5, 2024, 3:46pm UTC](https://community.weweb.io/t/filter-with-inner-join-in-supabase/13752 "2024-10-05T15:46:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![enzocarmo](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/enzocarmo/32/7681_2.png) [@enzocarmo](https://community.weweb.io/u/enzocarmo)\
**Post date:** [October 5, 2024, 3:46pm UTC](https://community.weweb.io/t/filter-with-inner-join-in-supabase/13752/1 "2024-10-05T15:46:36Z")

</div>

@Broberto

Hello everyone and broberto, not only can he answer me but I’m almost sure he has the answer. I learned from you how to do inner join with supabase in advanced mode, but how do I filter something that came from the inner join and not from the main table? I couldn’t

---

<div class="post-metadata">

**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\
**Post date:** [October 5, 2024, 4:13pm UTC](https://community.weweb.io/t/filter-with-inner-join-in-supabase/13752/2 "2024-10-05T16:13:43Z")

</div>

Hello Enzo 🙂 I’m super glad you learnt the JOINs, it’s super handy indeed. Sam had a similar question in my main topic, you might wanna have a look.

> [@\[Supabase\] Become a Supabase Magician in WeWeb (With Examples of JOINS etc.)](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/8):
>
> If you go and use a workflow instead of a Collection, you should be able to set a filter on a news.active column and it could work like this, as that is the “true reference” to that column.

---

<div class="post-metadata">

**Author:** ![enzocarmo](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/enzocarmo/32/7681_2.png) [@enzocarmo](https://community.weweb.io/u/enzocarmo)\
**Post date:** [October 6, 2024, 1:48am UTC](https://community.weweb.io/t/filter-with-inner-join-in-supabase/13752/3 "2024-10-06T01:48:00Z")

</div>

So the filter doesn’t work as a collection, right?

In the form of collections, I tried two ways to do what I need: 1- using the supabase plugin 2- trying the rest of supabase

```auto
create table
  public.produtos (
    id uuid not null default gen_random_uuid (),
    codigo text null,
    nome text null,
    marca uuid null,
    categoria uuid null,
    fornecedor_padrao uuid null,
    unidade text null,
    ncm text null )

```

```auto
create table
  public.produtos_eans (
    id uuid not null default gen_random_uuid (),
    ean text null,
    data_cadastro timestamp with time zone null,
    data_alteracao timestamp with time zone null,
    alterado_por uuid null,
    produto uuid null
  )

```

I have these two tables, I needed to select “produtos” by doing an inner join with “produtos\_eans” but being able to filter the “produtos\_eans.ean” column

Using the supabase plugin, it doesn’t work as you explained. From the rest of the api I don’t know why but it also doesn’t let me filter a column that is from a table coming through join

solutions?

Note: Because it is software for my company where only my employees will use it and will have restricted access, I thought about using the SQL plugin, but the performance is poor, right?

---

<div class="post-metadata">

**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\
**Post date:** [October 6, 2024, 7:03am UTC](https://community.weweb.io/t/filter-with-inner-join-in-supabase/13752/4 "2024-10-06T07:03:39Z")

</div>

Yes, you’re right, you need to switch to the Workflow Actions, because the Collections don’t allow custom keys.