mysql count 好几个表_COUNT(*)从MySQL中的多个表

如何从MySQL中的多个表中选择COUNT(*)？

如：

SELECT COUNT(*) AS table1Count FROM table1 WHERE someCondition

JOIN??

SELECT COUNT(*) AS table2Count FROM table2 WHERE someCondition

CROSS JOIN? subqueries?

SELECT COUNT(*) AS table3Count FROM table3 WHERE someCondition

编辑：

目标是返回这个：

+-------------+-------------+-------------+

| table1Count | table2Count | table3Count |

+-------------+-------------+-------------+

| 14 | 27 | 0 |

+-------------+-------------+-------------+