我如何结合两个查询，将计数行?

Question

如何将这两个查询合并为一个查询呢?

$mayorcountqry = $conn->prepare("SELECT VOTE_STATUS FROM voters where VOTE_STATUS = ? AND prcnt_no = ? ");
$mayorcountqry->execute([$MAYOR,$prcnt_no]);
$countmayor = $mayorcountqry->rowCount();   

$triocountqry = $conn->prepare("SELECT VOTE_STATUS FROM voters where VOTE_STATUS = ? AND prcnt_no = ? ");
$triocountqry->execute([$TRIO,$prcnt_no]);
$triocount= $triocountqry->rowCount();

Answer 1

您尝试过SQL Union吗?

语法:

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;

你可以只计算每一个。