The following query shows coaches of teams that played on 9 June 2012. JOIN has been used to make relation between two tables. Because of this we can select coach from eteam table and mdate from game table.

Show stadium and mdate of matches played by the team having 'Vicente del Bosque' as the coach.