# GET data from supabase with join tables, and NOT IN and IN condition, or with filter to other collection

**URL:** <https://community.weweb.io/t/get-data-from-supabase-with-join-tables-and-not-in-and-in-condition-or-with-filter-to-other-collection/3829>\
**Category:** Ask us anything\
**Tags:** supabase\
**Created:** [August 10, 2023, 3:24am UTC](https://community.weweb.io/t/get-data-from-supabase-with-join-tables-and-not-in-and-in-condition-or-with-filter-to-other-collection/3829 "2023-08-10T03:24:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![luissh84](https://avatars.discourse-cdn.com/v4/letter/l/b77776/32.png) [@luissh84](https://community.weweb.io/u/luissh84)\
**Post date:** [August 10, 2023, 3:24am UTC](https://community.weweb.io/t/get-data-from-supabase-with-join-tables-and-not-in-and-in-condition-or-with-filter-to-other-collection/3829/1 "2023-08-10T03:24:05Z")

</div>

Anyone help me to know how to get data using conditions with inner join clause in Supabase, I’m developing an app for leasing management, I want to assign assets to an employee, if the assets is assigned to another employee I don’t want to get this assets in the collection, here are the tables

 ![Captura de pantalla 2023-08-09 a la(s) 21.18.26](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/8/8a9df33966bcaaaa7046c36f5704e780024aeddb.png)

And here is the WeWeb collection, if I use the filter option, I have only the option to set an specific element of the collection assignments

---

<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:** [August 10, 2023, 11:06am UTC](https://community.weweb.io/t/get-data-from-supabase-with-join-tables-and-not-in-and-in-condition-or-with-filter-to-other-collection/3829/2 "2023-08-10T11:06:45Z")

</div>

Hey, check this out 🙂

> [@Supabase - Is it possible to use JOIN statements from within the WeWeb Plugin?](https://community.weweb.io/t/supabase-is-it-possible-to-use-join-statements-from-within-the-weweb-plugin/3133):
>
> Hello, I’m wondering whether I could make this query with the Supabase Plugin alone, or I need to do this with a PostgreSQL function and do a REST API request as I’m doing now, It would be great to have it in the Plugin, as we could use auth for RLS slight_smile

---

<div class="post-metadata">

**Author:** ![luissh84](https://avatars.discourse-cdn.com/v4/letter/l/b77776/32.png) [@luissh84](https://community.weweb.io/u/luissh84)\
**Post date:** [August 10, 2023, 5:02pm UTC](https://community.weweb.io/t/get-data-from-supabase-with-join-tables-and-not-in-and-in-condition-or-with-filter-to-other-collection/3829/3 "2023-08-10T17:02:15Z")

</div>

Thanks @Broberto, do you know if can we use that format direct in Weweb advanced mode ?

---

<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:** [August 10, 2023, 7:21pm UTC](https://community.weweb.io/t/get-data-from-supabase-with-join-tables-and-not-in-and-in-condition-or-with-filter-to-other-collection/3829/4 "2023-08-10T19:21:48Z")

</div>

You definitely can, in fact i did it and it worked 🙂 It might give you some errors, but when you open up the error log, you’ll see reccomendations from Supabase on how to fix it very often.