1-The first example shows the goal scored by a player with the last name 'Bender'. The * says to list all the columns in the table - a shorter way of saying matchid, teamid, player, gtime Modify it to ...

Use the INNER JOIN clause to combine rows from multiple tables based on the foreign key value Use the OUTER JOIN clause to include rows having null values in the foreign key Press the Execute button ...