I'm new at this but I'm trying to combine the columns in the SELECT statement from the player_game_log table and the date column in the game table, but I get No such table as game.date and when I remove the .date. then I get an error saying ambiguous column name: game_id. What am I getting wrong?
-- Jalen Green player_id = 1630224
SELECT player_id, game_id, pts, reb, ast
player_game_log.game_id = game.game_id
WHERE player_id = 1630224
ORDER BY pts DESC;