Enter 1998 December/ENTER12_1.iso/Dema/prosper/STANY.SQL

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;