SupabaseS
Supabase•2y ago
Dontblink

Query table with multiple cols with same foreign key. Join tables.

I have two tables structured in the following ways

I'm trying to get the equipable_items when I query character_equipment like this

But I'm getting this error
Could not embed because more than one relationship was found for 'character_equipment' and 'equipable_items


Now It looks like I can do something like this 

equipable_items!character_equipment_hands_fkey


instead of equipable_items(*), but I need to get the individual data for the item for each col.

Is this just a bad way I've set up my tables or am I not using the supabase call correct?

Thanks!
Was this page helpful?