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
Now It looks like I can do something like this
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!
I'm trying to get the equipable_items when I query character_equipment like this
But I'm getting this error
Now It looks like I can do something like this
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!
