# help
- f
Flyken
07/27/2021, 5:25 PM@User huh? - f
frubalu
07/27/2021, 5:25 PMoh right, i mistyped my answer. - f
frubalu
07/27/2021, 5:25 PMCopy codelet { data, error } = await supabase.from('users_games').select().eq('user_id', user.id); - f
Flyken
07/27/2021, 5:26 PMbut - f
Flyken
07/27/2021, 5:26 PMuser_id is not a row - s
Scott P
07/27/2021, 5:26 PM
would be a columnuser_id - f
frubalu
07/27/2021, 5:26 PMthis is more or less a join table, right? you might want to rename your
column tousers
insteaduser_id - f
Flyken
07/27/2021, 5:28 PMnow its just not returning - f
Flyken
07/27/2021, 5:28 PMwhy is it undefined on first render?????? - f
frubalu
07/27/2021, 5:28 PMwhat'd you change? - f
Flyken
07/27/2021, 5:29 PMi renamed these - f
Flyken
07/27/2021, 5:29 PMrow_id is now key - f
Flyken
07/27/2021, 5:29 PMand id is the user - f
Flyken
07/27/2021, 5:29 PMits not returning at all - f
frubalu
07/27/2021, 5:29 PMummm, this is kind of confusing haha - f
Flyken
07/27/2021, 5:30 PMthis is so frustrating - f
Flyken
07/27/2021, 5:30 PMshould we start over from the wanted result? - f
frubalu
07/27/2021, 5:30 PMok do this: 1. change row_id to id 2. change id to user_id 3. change games to game_id - f
frubalu
07/27/2021, 5:30 PMthat'd be a proper join table - f
frubalu
07/27/2021, 5:32 PMwtf does that mean... - s
Scott P
07/27/2021, 5:32 PMI've seen that pop up a few times lately, and I'm not sure why it happens or how to fix it 😦 - f
frubalu
07/27/2021, 5:32 PMare you able to drop that entire table and rebuild it? - f
Flyken
07/27/2021, 5:33 PMthere - f
frubalu
07/27/2021, 5:33 PMok nice! - f
Flyken
07/27/2021, 5:33 PMi had to remake the columns - f
frubalu
07/27/2021, 5:33 PMperfect - f
Flyken
07/27/2021, 5:33 PMok so - f
Flyken
07/27/2021, 5:33 PMwhat should my query look like? - f
frubalu
07/27/2021, 5:33 PMwait one more thing, does your third column reference the
table?game_directory - f
Flyken
07/27/2021, 5:33 PMyea