While creating a crosstab query, you can base it on a table or another query.
In this tutorial we will base it on another query. The query will return the list of artist, genres and albums from the database. The genre is linked to the album –not the artist. So, an artist can release different album from different genres.