简单的MYSQL计数，分组，不使用Pentaho Report Designer CE

I need to write a query which will pull from two different tables, count the results and return to me in one row, the total results. I need to write a query which will pull from tw