Inner Joins (II)
Here, you'll continue to practice your INNER JOIN skills. We'll use the album table as last time, but will join it to a new table - artist - which consists of two columns: artist_id and name.
Deze oefening maakt deel uit van de cursus
Introduction to SQL Server
Oefeninstructies
- Select the
album_idandtitlecolumns fromalbum(the main source table name). - Select the
namecolumn fromartistand alias it asartist. - Identify a common column between the
albumandartisttables and perform an inner join.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select album_id and title from album, and name from artist
SELECT
___,
___,
___ AS artist
-- Enter the main source table name
FROM ___
-- Perform the inner join
INNER JOIN ___ on ___.___ = ___.artist_id;