Facebook
From Sweltering Prairie Dog, 8 Years ago, written in Oracle 9.2 PL/SQL.
This paste is a reply to Re: Re: Re: Re: Re: Untitled from Morose Giraffe - view diff
Embed
Download Paste or View Raw
Hits: 525
  1. CREATE VIEW stan_zapasow AS
  2. SELECT t.kod, t.nazwa, SUM(z.ilosc) AS STAN
  3. FROM towary t JOIN zasoby z ON t.id=z.towar
  4. GROUP BY t.nazwa, t.kod;