RE: SQL

• Previous message: Zuzula Vladislav: "RE: priehladny podklad IKONY"
• Maybe in reply to: Ladislav Fabian: "SQL"
• Next in thread: Ladislav Fabian: "RE: SQL"
• Reply: Ladislav Fabian: "RE: SQL"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Zdar a silu Ladislav, dna 06.12.2001 si napisal(a):

> 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
> 

zeby takto? neviem urcite

select  cislo_objednavky, sum( a tu treba dat naz. pola verim ze sa vola
suma)
from objednavky
having uzivatel like "$uzivatel"
group by cislo_objednavky

-- 
s pozdravom
AleXXX

• Previous message: Zuzula Vladislav: "RE: priehladny podklad IKONY"
• Maybe in reply to: Ladislav Fabian: "SQL"
• Next in thread: Ladislav Fabian: "RE: SQL"
• Reply: Ladislav Fabian: "RE: SQL"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 07. 12. 2001, 13:23 CET