Database MySQL: Joining Tables and Aliasing challenge

Hi Remi, So the first time I went through this I actually had to read the statement over and over again to make sense of exactly what it wants to see.

The challenge is asking you to SELECT specific columns FROM a table and INNER JOIN them to another table ON specific id matching a value. so basically the answer is:

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

SELECT (title column from MOVIES) , (name column from GENRES) FROM (movies table) INNER JOIN (GENRES to the FROM table[MOVIES]) ON (match MOVIES table genre_id column WITH the value from the GENRES table ID column).

I hope I didnt make that TOO confusing. But that is how my brain interprets it. I am no expert on MySQL, someone else could probably break it down better than I just did. But that answer should work out for you.

Thanks Chris. Your explanation of how it works is spot on. I'm not too sure given the way the challenge is written that I would have came to the idea of using movies.genre_id and genres.id. The wording leads you to write it the way I wrote it that generates an error.

I was wondering why the seemingly extra column info was included. Now I know why. The challenge could stand to written differently. (AND I put this in the wrong box LOL)

SELECT movies.title, genres.name FROM movies LEFT OUTER JOIN genres ON movies.genre_id;

This is what I keep putting in for the second question, but it keeps getting an error. What am I doing wrong. At least the data output below looks correct? UGH.

Ah, perfect. Thanks for the hint. I can't believe I didn't try that. Oh, well. It's always the last place you look. ;)

I am stuck on 2 of 2. It sounds like you are referencing it here. Im not sure what you mean.

the problem with the first question is that the question itself mentions nothing about actually using the 'genre_id'

2nd answer.

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

I got this to work by copying Chris's answer, but I did not learn anything from this challenge or video. Really poorly done.

This one was tough for me too. Read a few tutorials, the videos and tasks were a bit confusing.

Yeah... I struggled with this too. Luckily found this thread.

I wouldn't say the challenge or video was "poorly" done. Anyone that has ever done MySQL statements never "got it" the first time. It does take practice because you basically need to visualize it while writing the statements on what you are actually trying to SELECT.

Imagine that your school teacher in Math class assigns you homework, but before leaving class the teacher hands each student the answer key to that homework after each day for the rest of the year. At the end of the year when you are expected to complete your Final exam without notes or an answer key, everyone that didn't study their work or research how numbers actually worked, will fail.

Having the answer given to you is useful for you to move on, but you learn nothing. If you will learn anything from coding it will be that Google is your best friend because everyone comes from a different background and there is no possible way that 1 instructor will give a one-answer fits all.

If you are completely confused after a video, the forums are kind of like your "in-class" questions where students like myself or staff can help you understand or give you a guiding hands to the right answer.