数据库如何实现先update 然后select

update LZ_COUNT_SOURCES_yue set CNS_DIAL_NUMBER = cishu
set CNS_LAST_CALL = zhthsj
select max(a.CAL_CALL_DATE_TIME) as zhthsj,COUNT(*) as cishu from LZ_CALL_LOG a
where CAL_CONNECT_TIME_LEN > 0 and CAL_CALL_DIRECT = 2

怎么合并成为一个sql语句

如果是sqlserver：


update LZ_COUNT_SOURCES_yue  set CNS_DIAL_NUMBER = aaa.cishu                                                           set CNS_LAST_CALL = aaa.zhthsjfrom
(select max(a.CAL_CALL_DATE_TIME) as zhthsj,COUNT(*) as cishu from LZ_CALL_LOG a) aaa
where CAL_CONNECT_TIME_LEN > 0 and CAL_CALL_DIRECT = 2

可以写个事务！事务的具体语法可百度！

感觉触发器可以的，更新完执行查询