A question about task 8 in JOIN

[betterMax]

Your correct code

SELECT DISTINCT player
FROM game
JOIN goal ON goal.matchid = game.id
WHERE (team1 = 'GER' OR team2 = 'GER')
AND teamid <> 'GER'

My wrong code

SELECT DISTINCT player
FROM game
JOIN goal ON goal.matchid = game.id 
WHERE (team1='GER' OR team2='GRE') 
AND teamid <> 'GER'

I really couldn't find the difference. But the answer is different. If I use your code, I can get one goal in match 1010 and one goal in match 2012. If I use my code, I can get two goals in 1001. The other four goals are the same. I am wondering if you can share your wisdom with me on this. Thanks a lot.

Btw here is the test link.

[akhil9506]

@betterMax I think you you should check either of team1 or team2 should be germany where as in your code you are checking team1 to germany and team2 to greece