Hi,

I have two tables and I'd like to query the last 20 comments, this works:

session.createQuery("from Comments order by cm_date desc").setMaxResults(20).list()

I'd like to make sure that there is no Comments from the same User in the last 20, any idea?

Thanks,

Angelo


public class Comments
{
private Long id;
private User user;
private Timestamp cm_date;
}

public class User {
private Long id;
}

Again, I'm just new myself but I'm guessing there's something like...