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

Supabase

Hey,

I have the following tables

inventory_batch
```
batch_id: uuid PK
created_at: int4
```

inventory_item
```
batch_id: uuid FK
name: varchar
```

Is it possible to select all `inventory_batch` and get all  `inventory_item` with the same batch_id for each row. Or do I have to make a separate call on inventory_item?

Hello <@548124767035719680>!
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.

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