Note: this isint related to my other thread.<BR><BR>Hey<BR><BR>Im writing a php app to collect statistics about our platform. I have about 40 different count(*) querys to run against a mysql database.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...