Answers for "select 2 table sql with foreign key"

SQL
0

select columns from 2 tables with foreign key

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;
Posted by: Guest on June-22-2020
0

select columns from 2 tables with foreign key

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;
Posted by: Guest on June-22-2020

Code answers related to "select 2 table sql with foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language