Dear Sir/Madam

I want to use the output of update statement in the select statement. But I couldn't.

My query is

select Table1.*, x.seqno
from Table1
cross join
(UPDATE z_addin_counter
SET seqno = seqno + 1
OUTPUT INSERTED.seqno ) x


Is there any possibility to join update with select?

With Thanks
Ksamy.