HAVING 使用 和 两个表之间更新（笔记）

SELECT APPROVAL_ID,count(STATION_SNAP_ID) from T_INVEST_STATION_APL

where APPROVAL_ID in (select DISTINCT PROJECT_ID from T_ARCHIVE_DETAIL where DATA_TYPE in ('1','2','3'))

and IS_DEL ='0'

GROUP BY APPROVAL_ID

HAVING count(STATION_SNAP_ID)>2;

--

UPDATE T_ARCHIVE_DETAIL a

SET a.ATTACHMENT_ID = (select id from T_PROJECT_CONTRACT_ATTACHMENT b where a.ATTACHMENT_CODE = b.ATTACHMENT_CODE)

WHERE a.ATTACHMENT_CODE IS NOT NULL and a.ATTACHMENT_ID IS  NULL;