# Supabase: Augment data fetch from two tables: Advanced data fetching or Join Table?

**URL:** <https://community.weweb.io/t/supabase-augment-data-fetch-from-two-tables-advanced-data-fetching-or-join-table/17953>\
**Category:** How do I?\
**Created:** [April 25, 2025, 2:31pm UTC](https://community.weweb.io/t/supabase-augment-data-fetch-from-two-tables-advanced-data-fetching-or-join-table/17953 "2025-04-25T14:31:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Toby007](https://avatars.discourse-cdn.com/v4/letter/t/c37758/32.png) [@Toby007](https://community.weweb.io/u/Toby007)\
**Post date:** [April 25, 2025, 2:31pm UTC](https://community.weweb.io/t/supabase-augment-data-fetch-from-two-tables-advanced-data-fetching-or-join-table/17953/1 "2025-04-25T14:31:32Z")

</div>

I’m looking to get multiple fields from a foreign key - This is the setup:

Table: jobs  
CompLink → Companies(id)  
Table: Companies

I tried this under the advanced mode:

```auto
id, 
isFeatured, 
isRemote, 
importId,
Companies: CompLink (Name),
Companies: CompLink (compAddress),
Companies: CompLink (country),
Companies: CompLink (compURL),
Companies: CompLink (compLogo)

```

but I get this error:  
table name “Jobs\_Companies\_1” specified more than once

I get that this might be inefficient, just curious which direction to go in? Do some table join and fetch that?

Thanks,  
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:** [April 25, 2025, 4:26pm UTC](https://community.weweb.io/t/supabase-augment-data-fetch-from-two-tables-advanced-data-fetching-or-join-table/17953/2 "2025-04-25T16:26:18Z")

</div>

```auto
id, 
isFeatured, 
isRemote, 
importId,
Companies:CompLink(Name, compAddress, country, compURL, compLogo)

```

or if you have a many to one relationship

```auto
id, 
isFeatured, 
isRemote, 
importId,
...CompLink(Name, compAddress, country, compURL, compLogo)

```

Also, using capitals in your tables is a horrible thing. Fix it. [Become a Supabase Magician in WeWeb (Tutorial With Examples) – Broberto](https://broberto.sk/radar/weweb/become-a-supabase-magician-in-weweb-with-examples/)

---

<div class="post-metadata">

**Author:** ![Toby007](https://avatars.discourse-cdn.com/v4/letter/t/c37758/32.png) [@Toby007](https://community.weweb.io/u/Toby007)\
**Post date:** [May 7, 2025, 10:34pm UTC](https://community.weweb.io/t/supabase-augment-data-fetch-from-two-tables-advanced-data-fetching-or-join-table/17953/3 "2025-05-07T22:34:06Z")

</div>

yuupp you’re right - thanks for this!