Supabase•4y ago•

2 replies

How can I use a join table to then select from a 3rd table

Hi guys, im migrating from firebase so im used to noSQL, so im looking for the best way to achieve the following:

I have a

listings

listings

listingLikes

listingLikes

and a

userData

userData

table.

I have the very standard setup of when a user likes a listing, a

listingLikes

listingLikes

row is created connecting the

listing

listing

and the

userData

userData

listingLikes

listingLikes

just contains a

listingId

listingId

and a

userId

userId

Using

supabase-js

supabase-js

how can i say "Go find all the

listingLikes

listingLikes

that has this

listing

listing

as the

listingId

listingId

, then get all the

userIds

userIds

and select them from the

userData

userData

table?

Supabase•4y ago•

2 replies

Hi guys, im migrating from firebase so im used to noSQL, so im looking for the best way to achieve the following:

I have a

listings

listings

listingLikes

listingLikes

and a

userData

userData

table.

I have the very standard setup of when a user likes a listing, a

listingLikes

listingLikes

row is created connecting the

listing

listing

and the

userData

userData

listingLikes

listingLikes

just contains a

listingId

listingId

and a

userId

userId

Using

supabase-js

supabase-js

how can i say "Go find all the

listingLikes

listingLikes

that has this

listing

listing

as the

listingId

listingId

, then get all the

userIds

userIds

and select them from the

userData

userData

table?