Check out example codes for "select columns from 2 tables with foreign key". It will help you in understanding the concepts better.

Code Example 1

SELECT user.name, movie.name
FROM user, movie, list
WHERE list.user_id  = user.id
  AND list.movie_id = movie.id
ORDER BY 1,2;

Code Example 2

SELECT user.name, movie.name
FROM user
JOIN list  ON list.user_id  = user.id
JOIN movie ON list.movie_id = movie.id
ORDER BY 1,2;

Learn ReactJs, React Native from akashmittal.com