-
Update + aggregate function
I am trying to connect those 2 things I am not geting anywhere, can anyone help me with this ?:
USE Piekarnia
SELECT
tbProdukt.NazwaProduktu,
tbJednostka.Nazwa AS Jednostka,
ROUND(SUM(tbSklad.Ilosc),2)AS SUMA
FROM tbProdukt INNER JOIN
tbSklad ON tbProdukt.IdProdukt = tbSklad.IdProdukt INNER JOIN
tbWyrob ON tbSklad.IdWyrob = tbWyrob.IdWyrob INNER JOIN
tbZamowienie ON tbWyrob.IdWyrob = tbZamowienie.IdWrob INNER JOIN
tbJednostka ON tbProdukt.IdJednostka = tbJednostka.IdJednostka
GROUP BY tbProdukt.NazwaProduktu, tbJednostka.Nazwa
UPDATE tbZapotrzebowanie
SET Zapotrzebowanie = SUMA
WHERE tbZapotrzebowanie.ID = tbProdukt.IdProdukt
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|