Mysql exercises ---- The JOIN operation, ---- thejoin

Mysql exercises ---- The JOIN operation, ---- thejoin

Game

Id	Mdate	Stadium	Team1	Team2
1001	8 Jun 2012	National Stadium, Warsaw	POL	GRE
1002	8 Jun 2012	Stadion Miejski (Wroclaw)	RUS	CZE
1003	12 Jun 2012	Stadion Miejski (Wroclaw)	GRE	CZE
1004	12 Jun 2012	National Stadium, Warsaw	POL	RUS
...

 

Goal

Matchid	Teamid	Player	Gtime
1001	POL	Robert lewandoski	17
1001	GRE	Dimitris Salpingidis	51
1002	RUS	Alan dzagev	15
1002	RUS	Roman Pavlyuchenko	82
...

 

Eteam

Id	Teamname	Coach
POL	Poland	Franciszek Smuda
RUS	Russia	Dick Advocaat
CZE	Czech Republic	Michal Bilek
GRE	Greece	Fernando Santos
...

 

JOIN and UEFA euro0 2012

This tutorial introducesJOINWhich allows you to use data from two or more tables. The tables contain all matches and goals from uefa euro 2012 Football Championship in Poland and Ukraine.

Summary