Posted By: ceny (C~eny) on 'CZdatabases'
Title:     Re: Konstrukce sql dotazu
Date:      Tue Jun 17 15:38:52 2003

SELECT Sum(PraceNaZakazce.Trvani) AS SumaTrvani, DenniSouhrn.Datum
FROM PraceNaZakazce 
INNER JOIN DenniSouhrn 
ON (PraceNaZakazce.DatumZahajeni = DenniSouhrn.Datum) 
AND (PraceNaZakazce.KodZam = DenniSouhrn.PracID)
GROUP BY DenniSouhrn.Datum 

v
Ceny

                      ~ ~ ~ ~ Prdi taky hadi? ~ ~ ~ ~