есть 2 запроса надо как то из 1 вычесть 2
select sum(c.cena_prodazhi*p.kolichestvo)
from cennik c
right outer join prodanni_tovar p
on
c.kod_tovara=p.kod_tovara and c.nomer_cennika=p.nomer_cennika
and c.nomer_nakladnoi=p.nomer_nakladnoi
и
select sum(t.stoimost*t.kolichestvo)
from tovar_po_nakladno
i t
Select SUM(v.summa)
from
(select sum(c.cena_prodazhi*p.kolichestvo) summa
from cennik c
right outer join prodanni_tovar p
on
c.kod_tovara=p.kod_tovara and c.nomer_cennika=p.nomer_cennika
and c.nomer_nakladnoi=p.nomer_nakladnoi
Union all
select -sum(t.stoimost*t.kolichestvo)
from tovar_po_nakladno
i t ) v
select sum(c.cena_prodazhi*p.kolichestvo)
- (select sum(t.stoimost*t.kolichestvo) from tovar_po_nakladno i)
from cennik c
right outer join prodanni_tovar p
on
c.kod_tovara=p.kod_tovara and c.nomer_cennika=p.nomer_cennika
and c.nomer_nakladnoi=p.nomer_nakladnoi
⇢