Robert is writing a query to pull data from two tables. One table (games) contains a list of video games. The field games.gameld is the primary key of games and the field highScores.gameld is the foreign key in the highScores table. The other table (highScores) contains player high scores. He has written the following in his query so far:
SELECT games.title, games.release Date, games.platform, highScores.score, highScores.player FROM schema.games
WHERE highScores.score > 100000
He wants his query to pull all the games, even if there are no high scores listed in the table highScores. What would be the join statement below that Robert would utilize?
O left join schema.highScores on highscores.gameld = games.gameld inner join schema.highScores on highscores.gamelD = games.gameld
O inner join schema.highScores where highScores.gameld - games.gameld left join schema.highScores on highscores.gamelD = games.gameld
O inner join schema.highScores on highscores.gamelD = games.gameld
O inner join schema.highScores where highScores.gamelD = games.gameld inner join schema.highScores having highScores.gamel D = games.gameld
O left join schema.highScores having highscores.gamelD = games.gameld
O right join schema.highScores on highscores.gamel D = games.gameld
O outer join schema.highScores on highscores.gamel D = games.gameld