Zanima me slijedeće:
ako imam upit tipa:
select s,
(select sum (a) from n1 where sifra=sf.s) as A,
(select sum (a) from n2 where sifra=sf.s) as B,
(select sum (a) from n1 where sifra=sf.s) - (select sum (a) from n2 where sifra=sf.s) as AMB
from sf
da li postoji neki način da se to upita slično slijedećem:
select s,
(select sum (a) from n1 where sifra=sf.s) as A,
(select sum (a) from n2 where sifra=sf.s) as B,
A-B as AMB
from sf
Ovako kako je napisano naravno ne radi...
Koliko sam uspio pretražiti forum o ovom ranije nije bilo riječi...
Ajmo stručnjaci...