Hi,
I have below mentioned table and I really can not figure out, haw to make
this select:
select coin_type, coin_routing, hodnota_czk, sum(pocet_minci)
from coins
where coin_routing = 'CASHBOX'
group by coin_type, coin_routing, hodnota_czk
class Coins(SQLObject):
_cacheValue = False
mincSerNumber = StringCol(length = 12, default=None)
tStamp = DateTimeCol(default = datetime.now)
coinType = StringCol(length = 2, default=None)
coinRouting = StringCol(length = 8, default=None)
hodnotaCzk = DecimalCol(size = 5, precision = 2)
pocetMinci = SmallIntCol()
aktualniIdText = StringCol(length = 20, default=None)
aktualniIdNumber = StringCol(length = 20, default=None)
kdoDalPokyn = StringCol(length = 8, default=None)
Many thanks for your hints and suggestions.
Petr Jakes
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
