The following query lists all the movie genre descriptions, along with movies that match them. For genres that have no matching movies, any data selected from the MOVIE table for that row will have no value and thus be set to NULL in the query results.

SELECT MOVIE_GENRE_DESCRIPTION AS GENRE, MOVIE_TITLE

 FROM MOVIE_GENRE LEFT OUTER JOIN MOVIE

 ON MOVIE_GENRE.MOVIE_GENRE_CODE = MOVIE.MOVIE_GENRE_CODE

 ORDER BY MOVIE_GENRE_DESCRIPTION;