SELECT matchid,player FROM goal
WHERE teamid = 'GER'
SELECT id,stadium,team1,team2
FROM game
where id=1012
select a.player,a.teamid,b.stadium,b.mdate
from goal as a
left join game as b
on a.matchid = b.id
where a.teamid = 'GER'
select a.team1,a.team2,b.player
from game as a
left join goal as b
on a.id=b.matchid
where b.player LIKE