Re: problem with distinct not solved by group by

You want the rows containing the maximum post_d for each movies_id group. As you've seen, this is tricky. Fortunately, the manual suggests three solutions to this problem . Michael Seth Leonard wrote: I have three tables:

problem with distinct not solved by group by

I have three tables: reviews users movies I am trying to select the latest 4 reviews for DIFFERENT movies. I can use the following query: SELECT reviews.movies_id, movies.movie_title, users.name, reviews.rating, reviews.post_d FROM reviews, users, movies WHERE reviews.user_id = users.user_id a