# help
- f
Flyken
07/27/2021, 7:45 PMyea - f
frubalu
07/27/2021, 7:46 PMcould you show me your
method again? might be able to simplify this quite a bitfetchGames() - f
Flyken
07/27/2021, 7:46 PMCopy codejs const fetchGames = async () => { if (!user) return; return await supabase.from('users_games').select().eq('user_id', user.id); }; - f
frubalu
07/27/2021, 7:47 PMsupabase.from('users_games').select('*, games(*)').eq('user_id', user.id); - f
frubalu
07/27/2021, 7:47 PMtry something like that - f
Flyken
07/27/2021, 7:48 PM:O - f
frubalu
07/27/2021, 7:48 PMyou're trying to query table relationships: https://supabase.io/docs/postgrest/client/select#query-foreign-tables - f
Flyken
07/27/2021, 7:48 PMits got a new object on it - f
Flyken
07/27/2021, 7:48 PMgames - f
Flyken
07/27/2021, 7:48 PMsorry if im seeming super noob on this - f
frubalu
07/27/2021, 7:48 PMall good - f
frubalu
07/27/2021, 7:49 PMdoes that nested object have the data that you're looking for? - f
frubalu
07/27/2021, 7:49 PMif it does, great. this will prevent you from making potentially dozens of db queries - f
Flyken
07/27/2021, 7:49 PMyea, it does :) - f
frubalu
07/27/2021, 7:49 PMawesome! - f
frubalu
07/27/2021, 7:50 PMthen you can always iterate over that data to set it to state if that's easier - f
Flyken
07/27/2021, 7:50 PMok so my question now - f
Flyken
07/27/2021, 7:51 PMi have
rightconst [games, setGames] = useState([]) - f
Flyken
07/27/2021, 7:51 PMhow do i put these objects into that as an array? - f
frubalu
07/27/2021, 7:52 PMwhat's your response look like from
?fetchGames() - f
Flyken
07/27/2021, 7:52 PMoh wait - f
Flyken
07/27/2021, 7:52 PMi see - f
Flyken
07/27/2021, 7:53 PMif i console log
, it returns the right thinggame.games - f
Flyken
07/27/2021, 7:53 PMjust as seperate logs - f
frubalu
07/27/2021, 7:54 PMso you'd probably run something like:Copy codesetGames(prev => [...prev, newGame ]) - f
Flyken
07/27/2021, 7:55 PMAAAYYYEEE - f
Flyken
07/27/2021, 7:55 PMi think it works - f
Flyken
07/27/2021, 7:56 PMyea - f
Flyken
07/27/2021, 7:56 PMit works :) - f
Flyken
07/27/2021, 7:56 PMthanks a bunch