[EMAIL PROTECTED] wrote: >>I pretty much have no idea how I can do this without nested queries (and >>to be frank not even how to do it with them) so I'd really appreciate >>any help! > > >>kind regards Philip > > > Try this as a starting point:
<snip> > I think you were having two mental problems: 1) how to GROUP BY across > tables (creating a JOIN). and 2) How to use a HAVING clause. If you Refer > To the Fine Manual (RTFM) you can get examples and more explanations of > both processes. Thanks a lot, this did the trick! kind regards Philip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]