Hi guys, need some help over here. I need to

Question

Hi guys, need some help over here. I need to

find out which movies are not watched by anyone. I have a "User" table and a "Movie" table many-to-many relationship. How can I achieve that in mysql? I was thinking something like "select m.id from movie m, watched_movies w where m.id not in(w.id)" but the response give me all the fields duplicated. Any help please?

P.S. watched_movies is the cross-join table between "user" and "movie".

0

14.10.2018

1 ответов

8 просмотров

Junaid Farooq · Accepted Answer

Junaid Farooq

Define the relationship between the user and movie tables

0

14.10.2018

Похожие чаты

Hi guys, need some help over here. I need to

1 ответов

Похожие вопросы