Supabase•4y ago•

13 replies

Join table multiple times ?

I have this table

stops

stops

- id - name
|- 1 - Cairo
|- 2 - Giza

- id - name
|- 1 - Cairo
|- 2 - Giza

and another table

trips

trips

- id - departure - arrival
|- 1 -     1     -   2

- id - departure - arrival
|- 1 -     1     -   2

the

departure

departure

column is a foreign key to

stops.id

stops.id

and

arrival

arrival

to the same

stops.id

stops.id

key.

Now I can't select from

trips

trips

while using

left join

left join

because of this error:

Failed to run sql query: table name "stops" specified more than once

Failed to run sql query: table name "stops" specified more than once

Of course I tried this first in SQL editor in supabase, but I'll use the js client for the project.