SupabaseS
Supabase•12mo ago
Ben

Client Library JOIN Queries

Hello there! 🙂

I am facing a little challenge in my Flutter App.

I have the following tables and want to perform a JOIN-Query on my Client - I replaced the real table names and purposes with this example situation for simplicity:

product.company (Saving all the companies)
product.employee (Saving all the employees)

relations.company_employee (company_id, employee_id foreign keys)

How can I perform a request to get the company including all the employees in one request? I have trouble dealing with the different schemas as they can't be provided inside the call.

Help would be much appreciated!

Best
Ben
Was this page helpful?