davocado
03/14/2022, 5:57 PMselect 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:
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!Needle
03/14/2022, 5:57 PM/title
command!
We have solved your problem?
Click the button below to archive it.