SQL

• Previous message: Kobylková Simona: "RE: GE Capital Bank"
• Next in thread: Likavcan, Alexander: "RE: SQL"
• Reply: Likavcan, Alexander: "RE: SQL"
• Reply: krutohlav: "Re: SQL"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Mam problem s jednym sql prikazom:
Potrebujem z tabulky vybrat objednavky podla zakaznika,
s tym, ze sa zobrazi cislo objednavky a vedla toho celkova
suma. S tymi objednavkami nemam problem, ale ako to urobit,
ked je viac poloziek na objednavke aby sa mi zratala suma?
zatial to mam takto:
SELECT 
 cislo_objednavky, suma 
FROM 
 objednavky 
WHERE
 uzivatel LIKE "$uzivatel"
GROUP BY
 cislo objednavky

Skusal som SELECT cislo_objednavky, SUM(suma), ale
akosi to nefunguje...

Lasky

• Previous message: Kobylková Simona: "RE: GE Capital Bank"
• Next in thread: Likavcan, Alexander: "RE: SQL"
• Reply: Likavcan, Alexander: "RE: SQL"
• Reply: krutohlav: "Re: SQL"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 06. 12. 2001, 09:17 CET