|
发表于 2019-4-1 14:21:27
|
显示全部楼层
SELECT
CYZJHM,
CYXM,
CBFBM,
cbfmc,
cbfdz
FROM
(
SELECT
CBF_JTCY.CYZJHM,
CBF.CYXM,
CBF.CBFBM,
CBF.cbfmc,
CBF.cbfdz
FROM
CBF_JTCY
LEFT JOIN CBF ON CBF_JTCY.CYZJHM = CBF.CYZJHM
) t
GROUP BY
t.CYZJHM,
t.CYXM
HAVING
count( * ) > 1
ORDER BY
t.CYZJHM |
|