mysqli - 将两个不同的查询作为单个 mysql 查询执行

Question

$query1 = "SELECT 
    SUM(dischargecount) AS dis, MONTHNAME(dischargedate) AS n
FROM
    user
WHERE
    DATE(dischargedate) BETWEEN '$from' AND '$to'
GROUP BY MONTH(dischargedate)";


$query2 = "SELECT 
    COUNT(DISTINCT response_user) AS val1,
    MONTHNAME(response_on) AS m
FROM
    response
WHERE
    response_on BETWEEN '$from' AND '$to'
GROUP BY MONTH(response_on)";

我想将这两个查询作为一个执行。

标签： mysqli

Answer 1

选择 col_name $q1,col_name $q2 from $query1 $q1,$query2 $q2 where condition1 AND condition2;