SQLZOO 答案6— JOIN

1.第一個例子列出球員姓氏為’Bender’的入球數據。 * 表示列出表格的全部欄位，簡化了寫matchid, teamid, player, gtime語句。

SELECT matchid, player
FROM goal
WHERE teamid = 'GER';

2.只顯示賽事1012的 id, stadium, team1, team2

SELECT id, stadium, team1, team2
FROM game
WHERE id = 1012;

3.修改它來顯示每一個德國入球的球員名，隊伍名，場館和日期
（思路：球员名和队伍名在goal表中，场馆和日期在game表中，将两个表连接（ON game.id = goal.matchid），最后限定条件是德国（where teamid = ‘GER’））

SELECT player, teamid, stadium, mdate
FROM goal AS a JOIN game AS b
ON(a.matchid = b.id)
WHERE teamid = 'GER';

4.列出球員名字叫Mario (player LIKE ‘Mario%’)有入球的 隊伍1 team1, 隊伍2 team2 和 球員名 player
（思路：team1 和 team2在game表中，player在goal中，将两表连接（ON game.id = goal.matchid），限定条件是球员名字叫Mario (player LIKE ‘Mario%’)）

SELECT team1, team2, player
FROM goal JOIN game
ON (goal