home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 1998 July
/
CHIP_CD_1998_07_PL.iso
/
SOFTWARE
/
TESTSOFT
/
PROSPER
/
STANY.SQL
< prev
next >
Encoding:
Amiga
Atari
Commodore
DOS
FM Towns/JPY
Macintosh
Macintosh JP
Macintosh to JP
NeXTSTEP
RISC OS/Acorn
Shift JIS
UTF-8
Wrap
Text File
|
1997-05-16
|
180 b
|
6 lines
select s.nr_tow,sum(s.ilosc),sum(wartosc)
from specyf s, faktury f
where (s.trns_nr=f.trns_nr) and f.typ in :typy_dokumentow
and f.nr_magazynu=:nr_magazynu
group by s.nr_tow;