27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT a.姓名 ,
COUNT(1) AS 相同数量
FROM AAA a
JOIN CCC c ON a.姓名 = c.姓名
AND a.电话 = c.电话
GROUP BY a.姓名
UPDATE a
SET a.编码 = b.编码b ,
a.姓名 = c.姓名c ,
a.电话 = c.电话c
FROM AAA a
JOIN BBB b ON a.IDa = b.IDb
JOIN CCC c ON b.编码b = c.编码c
WHERE b.时间b BETWEEN '2017-01-01' AND '2017-03-06'