select value from row-1 MS SQL from multiple table

Question

https://www.c-sharpcorner.com/forums/select-value-from-row1-ms-sql

 

Solution from one table work...from multiple tables?

 

 

 

 

 

with cte as (
select iznos_sa_porezom as 'Duguje', '0.00' as 'Potražuje',
ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RN  from dbo.mp_ulazni_racun_roba_lista
where redni_broj  IS NOT NULL  group by iznos_sa_porezom
union all
select  iznos_sa_porezom as 'Duguje', '0.00' as 'Potražuje',
ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RN from dbo.mp_ulazni_racun_ostalo_lista
where redni_broj  IS NOT NULL   group by iznos_sa_porezom)
select [Duguje], [Potražuje],
 (SELECT sum(Duguje-Potražuje) FROM cte t2 WHERE t2.RN <= cte.RN) AS Saldo
from cte