Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I'm trying to undestand how to properly use relational data. I have a table "Projects" and "Managers". Each project has a column `manager` with a foreign key to manager's `id`. So. what if I want to display manager's `name` row instead of `id`?

I've tried this but it doesn't work
```Svelte
{#each projects as project}        
    {project.manager.name || ''}       
{/each}
```

Hello <@73809658090881024>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

Hi <:vmathi:812484657547313212> What does your ``projects`` variables contains? <@73809658090881024>

Hey <:bmo_howdy:640746864567779340>  It's data from Supabase's `projects` table

```js
    async function getProjects() {
        try {
            loading = true;
            let { data, error } = await supabase
                .from('projects')
                .select('*')
                .eq('isActive', true)
                .order('created_at', { ascending: false });
            projects = data;
        } catch (error) {
            alert(error.message);
        } finally {
            loading = false;
        }
    }
```

Okay, after some googling I found a solution:
```js
.select('*, manager ( name )')
```

Exactly, this is the way to fetch deep datas :p

Thread was archived by <@73809658090881024>. Anyone can send a message to unarchive it.