SELECT
*
FROM
(
SELECT
t1.projectCustomerPhone phone,
count(t2.phone) count
FROM
(
SELECT
*
FROM
t_projectcustomers
WHERE
projectId = 'ac500158ccd148e9a9e9fd3c42f5d76a'
) t1
LEFT JOIN (
SELECT
*
FROM
t_visitrecords
WHERE
writeState = 1
) t2 ON t1.projectCustomerPhone = t2.phone
GROUP BY
t1.projectCustomerPhone
) AS cc
WHERE
cc.count >= 2
mysql查询一张表字段在另一张表中出现的次数
最新推荐文章于 2024-07-22 03:05:39 发布