您可以通过使用子查询来实现,每个tableCount一个子查询:
SELECt (SELECT COUNT(*) FROM table1 WHERe someCondition) as table1Count, (SELECt COUNT(*) FROM table2 WHERe someCondition) as table2Count, (SELECt COUNT(*) FROM table3 WHERe someCondition) as table3Count

您可以通过使用子查询来实现,每个tableCount一个子查询:
SELECt (SELECT COUNT(*) FROM table1 WHERe someCondition) as table1Count, (SELECt COUNT(*) FROM table2 WHERe someCondition) as table2Count, (SELECt COUNT(*) FROM table3 WHERe someCondition) as table3Count