06_JOIN_UEFA EURO 2012_6.sql

/* Problem Statement:

To JOIN game with eteam you could use either
game JOIN eteam ON (team1=eteam.id) or game JOIN eteam ON (team2=eteam.id)

Notice that because id is a column name in both game and eteam you must specify eteam.id instead of just id

List the the dates of the matches and the name of the team in which 'Fernando Santos' was the team1 coach.

*/

-- Solution: 

SELECT mdate, teamname 
FROM game JOIN eteam
ON game.team1 = eteam.id 
WHERE coach = 'Fernando Santos';