Hello, I can't find out how to replicate a left jo...
# help
d
Hello, I can't find out how to replicate a left join in supabase js cli. some postgresql query like:
Copy code
select s.id, s.status, u.id, u.firstname, u.lastname
  from subscriptions as s
  left join users as u on s.user_id = u.id
  where u.firstname = 'John';
will only return subscriptions of users called 'John'. but with:
Copy code
supabaseClientCli
        .from('subscriptions')
        .select('id, status, user:users(id, firstname, lastname)')
        .eq('user.firstname', 'John')
I get all subscriptions, with
user: null
if
user.firstname
isn't John... help appreciated!
n
Hello @davocado! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! 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.