# Issue reading in relational data from supabase **URL:** \ **Category:** Ask us anything\ **Created:** [October 9, 2024, 3:15pm UTC](https://community.weweb.io/t/issue-reading-in-relational-data-from-supabase/13837 "2024-10-09T15:15:10Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![metalsteve81](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@metalsteve81](https://community.weweb.io/u/metalsteve81)\ **Post date:** [October 9, 2024, 3:15pm UTC](https://community.weweb.io/t/issue-reading-in-relational-data-from-supabase/13837/1 "2024-10-09T15:15:10Z")
I am using a collection for a list, in the supabase table for this collection I have a column that references the user\_data table but when I have the data in weweb it only shows the uuid of user\_data and not the full user\_data data. How do I get it to show everything from that table? Thank you. ---
**Author:** ![metalsteve81](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@metalsteve81](https://community.weweb.io/u/metalsteve81)\ **Post date:** [October 10, 2024, 4:51am UTC](https://community.weweb.io/t/issue-reading-in-relational-data-from-supabase/13837/2 "2024-10-10T04:51:41Z")
I realized that I needed to create a join in the sql editor. Which is really alien to me but this is what I have and its still not working, I would appreciate some help. Im not sure what I am doing wrong. I am joining them by the user\_id in the artist profile table. It shows the 2 rows of the table I am referencing but it only shows the uuid inside weweb. ![issues](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/7/705e5670b9f8822508cb6509a088d4c0e56d9975.png) ---
**Author:** ![metalsteve81](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@metalsteve81](https://community.weweb.io/u/metalsteve81)\ **Post date:** [October 10, 2024, 6:10am UTC](https://community.weweb.io/t/issue-reading-in-relational-data-from-supabase/13837/3 "2024-10-10T06:10:44Z")
figured it out. had to create something called a view and then create a collection from the new view table thats created…but then there was an issue with ids because both tables had an id column. So I had to call each one of the columns separately and not the id from one of the tables. It seems odd to me that there is no way to say “all but this column”, which would have been easier, but this is what it looked like for anyone else who might get this issue. ![issues](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/2/205ebb9619783ebecc6a76f06f3de0dca3536bea.png) ---
**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 10, 2024, 7:02am UTC](https://community.weweb.io/t/issue-reading-in-relational-data-from-supabase/13837/4 "2024-10-10T07:02:40Z")
You could’ve done this from the front-end btw, whihout having a view. > **[Become a Supabase Magician in WeWeb (Tutorial With Examples) – Broberto](https://broberto.sk/radar/weweb/become-a-supabase-magician-in-weweb-with-examples/#we-actually-can-get-the-best-of-both-worlds)** > > Discover advanced techniques for using Supabase with WeWeb. Enhance your apps with these advanced examples and interactive WeWeb examples. ---
**Author:** ![metalsteve81](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@metalsteve81](https://community.weweb.io/u/metalsteve81)\ **Post date:** [October 10, 2024, 2:29pm UTC](https://community.weweb.io/t/issue-reading-in-relational-data-from-supabase/13837/5 "2024-10-10T14:29:55Z")
That was a lot easier. Thank you. I will keep that in mind next time. It does give me this error in weweb under the advanced window but it still works " You have invalid fields in your advanced selection" ---
**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 10, 2024, 7:43pm UTC](https://community.weweb.io/t/issue-reading-in-relational-data-from-supabase/13837/6 "2024-10-10T19:43:09Z")
Yeah it’s a WeWeb thing 🙂 It works tho