sql如何用with as的结果作where条件

with temp
as
(
select id,inviteid
from Sa_Users
where id=@currentuid
union all
select a.id,a.inviteid
from Sa_Users a
inner join temp on a.id = temp.inviteid
) select id from temp;

这里查出id后 想要update XXX set count=count+1 where id in ( temp中查出的id集合 ) 如何写

示例代码如下：

;with a as(select * from table_a),
b as (select * from a where id in(3,4,5))
select * from b

记得一定要有逗号间隔开两个查询，最后一个查询前是没有逗号的

搜一下：sql如何用with as的结果作where条件