[ Samo polako @ 24.10.2005. 18:07 ] @
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... |