PARFEMY ZAJEM
Kategorie: ostatni


SELECT F.zbozi_id ,Z.s53,Z.s58,Z.nazev ,Z.objem, Z.cena, sum(F.ks) kusu
FROM zbozi_faktura F , zbozi Z
WHERE Z.id_zbozi = F.zbozi_id
GROUP BY zbozi_id
ORDER BY kusu DESC
-------------------------------

SELECT F.zbozi_id ,Z.s53,Z.s58,Z.nazev ,Z.objem, Z.cena, sum(F.ks) kusu
FROM zbozi_faktura F , zbozi Z
WHERE Z.id_zbozi = F.zbozi_id
AND Z.objem LIKE "%TESTER%"
GROUP BY zbozi_id
ORDER BY kusu DESC
-------------------

SELECT sum(F.ks) kusu
FROM zbozi_faktura F , zbozi Z
WHERE Z.id_zbozi = F.zbozi_id
AND Z.objem LIKE "%TESTER%"

----------------------------

SELECT sum( F.ks ) kusu
FROM zbozi_faktura F, zbozi Z
WHERE Z.id_zbozi = F.zbozi_id


13.11.2008 12:39:04