The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Count Joining Multiple Tables

Working on a query that I'm pretty sure is out of the scope of my skills. I've done fine thus far with simple queries contained within 1 table but I'm not sure how to go about this. Here's the pseudo-code I have currently.

And if you have a second... I'm all self taught when it comes to this stuff, mostly learning from debugging other peoples code and looking up things on msdn or w3c from time to time. Would you recommend anything beyond posting here when I get stuck? A book, nice manual with good examples, or any tips for learning? I'd much rather be able to do this on my own but I'm really in awe that there is a community like this to help people (beginners are people too!) out.