How to select multiple counts from multiple tables

[eluser]jedd[/eluser]
Yes, I understand that you're using the word random when you mean wrong.

My point is that unless you get *different* results every time you run that query, then the results aren't actually random. By looking at what the results are showing you - ie. by looking for patterns in your test data - you can work out what's going wrong with your query. In other words, I'm suggesting a way of identifying the problem.

Alternatively you can just wait for someone really smart to come along and identify the problem.