lundi 9 novembre 2015

How to return the values that do not appear in both columns?

I am trying to learn some SQL and I have these two tables and i would like to make a query that selects the titles that have no reviews.Can you please help me?

Movies

Rating

This is what i thought i should be, but it seems pretty far from it:

SELECT DISTINCT title

FROM Movie, Rating

WHERE Movie.mID != Rating.mID;

Aucun commentaire:

Enregistrer un commentaire