SELECT
province.province, COUNT(lujing.id)
FROM
lujing,
province,
address
WHERE
lujing.addr_id = address.id
AND address.province = province.province
AND lujing.id IN (SELECT
lujing.id AS id
FROM
lujing,
address
WHERE
lujing.addr_id = address.id)
GROUP BY province
mysql的嵌套查询
最新推荐文章于 2024-03-16 15:29:24 发布