The code I am using for the challenge (addendum to my previous message about the code challenge for Joining Tables/alias

You need show only two fields. First - movie "title" Second - genre "name"

You need join movies and genres tables, on the fields movie "genre_id" and genres "id"

Hi Nancy,

I'm not sure I understand the error message you've described in your post but let me try and help you solve the problem anyway.

First you need to select movies.title and genres.name instead of * (which means everything, all columns from your table) in your select statement.

You're almost right with your INNER JOIN but to make it clear, you'll notice the movies table has a column movies.genre_id and the genres table has a column genres.id. These two columns are equal as in they both refer to the same value so it would be the common factor you would join the two tables with. The movies table uses the genre_id to link the movie to the particular genre. So you'll need to make your join look something like this: INNER JOIN genres ON movies.genre_id = genres.id. You can see this in the code snippet I've made for you below.

SELECT movies.title, genres.name FROM movies INNER JOIN genres ON movies.genre_id=genres.id;

Hope that helps. Good luck!