SELECT sum(cnt) FROM (
SELECT COUNT(xmid) AS cnt FROM zxw_zxyy WHERE xmid REGEXP '(5)' UNION ALL SELECT COUNT(xmid) AS cnt FROM zxw_zxyy_mfbjlf WHERE xmid REGEXP '(5)') AS countdata SELECT COUNT(xmid) AS cn
阅读背景：
sql查询问题，没有关联的两张表
来源：互联网
分享到：
