MySQL subquery unwanted result -
so have come subquery select movies.movieid, movies.user movies movies.user in(select movies.user movies movies.movieid = '19') , movies.movieid <> (select movies.movieid movies movies.user='5' , movies.movieid = '19') , movies.movieid <> '19' and gives me result -------------------------- | movieid | user | -------------------------- | 20 | 4 | -------------------------- | 21 | 4 | -------------------------- | 22 | 5 | -------------------------- | 23 | 4 | -------------------------- how can rid of result user 5? i think problem @ and movies.movieid <> (select movies.movieid movies movies.user='5' , movies.movieid = '19') ...