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
I have the very standard setup of when a user likes a listing, a
Using
I have a
listings , listingLikes and a userData table.I have the very standard setup of when a user likes a listing, a
listingLikes row is created connecting the listing and the userData. listingLikes just contains a listingId and a userIdUsing
supabase-js how can i say "Go find all the listingLikes that has this listing as the listingId, then get all the userIds and select them from the userData table?