Okay you specialists... get ready for this one!

I'm working on a PHP/MySQL site for a book publisher and I'm stuck !
In order to give all of you a good idea of the problem I'm facing, I've put up a php page where everything is explained in detail (tables, queries, problem, ...). I thought things would be clearer if I could show them in a broader context.
You can visit it here: www.ludion.be/forumexample.php

If anyone out there can help me I'd love to here it...
Thanks already

You need to write a statement that joins the different tables. I do not think subqueries are available yet.

Hmm, just what I already figured... A join statement. And do you have any suggestion what kind of join: left, right, inner...

Thanks again.

Sorry I didn't have the time to go into much depth with your problem. My suggestion would be trial and error. Start with a simple JOIN, then go with LEFT and RIGHT. Once you have the statement I'll be glad to review it if you have problems