Posted by Goomba on 04/02/06 06:39

i need to combine two tables, then retrieve unique results. this works, but
it is also outputting all the movie_ids in mMovies as well, which results in
duplicates. i only want one. how can i make this work? Thanks!!

SELECT DISTINCT mMovies_Genres.movie_id, title_the, title, season, genre_id
FROM mMovies, mMovies_Genres
WHERE mMovies.movie_id = mMovies_Genres.movie_id
AND bonusDisc is null

[Back to original message]