# Table Joins in weweb

**URL:** <https://community.weweb.io/t/table-joins-in-weweb/3448>\
**Category:** Ask us anything\
**Tags:** design, supabase\
**Created:** [July 10, 2023, 5:21am UTC](https://community.weweb.io/t/table-joins-in-weweb/3448 "2023-07-10T05:21:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mujtaba026](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@mujtaba026](https://community.weweb.io/u/mujtaba026)\
**Post date:** [July 10, 2023, 5:21am UTC](https://community.weweb.io/t/table-joins-in-weweb/3448/1 "2023-07-10T05:21:40Z")

</div>

I have a collection which is a view and in that view there is data coming from 2 tables.  
i wanted to ask if we can create view in configuration step of the collection or in weweb instead of making the view in supabase because it makes the fetching step from supabase too slow because the data is 1.5 million, so what i want to ask is if weweb provides us with a step in which we can manually join the tables in weweb instead of supabase or just create a view in weweb

---

<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:** [July 10, 2023, 8:32am UTC](https://community.weweb.io/t/table-joins-in-weweb/3448/2 "2023-07-10T08:32:26Z")

</div>

You can do this, but it is not well documented on either the WeWeb’s side and neither on the Supabase’s side I made it work some time back, but it is not really as straightforward.

> [@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:** ![mujtaba026](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@mujtaba026](https://community.weweb.io/u/mujtaba026)\
**Post date:** [July 10, 2023, 3:32pm UTC](https://community.weweb.io/t/table-joins-in-weweb/3448/3 "2023-07-10T15:32:27Z")

</div>

thanks i’ll look into it