Supabase API query join on multiple fields
Let's say I want to join profile on sender_id and receiver_id. Is this a valid syntax? PS: It errors with 'couldn't find relationship between tables'
return _client
.from(_conversationTable) //
.select('''
id,
sender:profile(*)&profile.user_id=sender_id,
receiver:profile(*)&profile.user_id=receiver_id,
item:item_id(*),
created_at
''')
.eq('id', conversationId)
.limit(1)
.single()
.execute()