Facebook
From Big Meerkat, 8 Years ago, written in Oracle 9.2 PL/SQL.
This paste is a reply to Re: Re: Re: Re: Untitled from Ample Penguin - go back
Embed
Viewing differences between Re: Re: Re: Re: Untitled and Re: Re: Re: Re: Re: Untitled
SELECT p.lp, t.kod, p.ilosc AS "ILOSC TOWARU", t.jednmagazynowa, 
CEIL(p.ilosc/t.iloscmagazynowa) AS "ILOSC JEDN. MAG." 
FROM stan_zapasow;POZYCJEDOKUMENTU p JOIN TOWARY t ON p.towary=t.id
WHERE p.dokument=2;