Re: [web2py] query in DAL

[Ovidio Marinho]

I am doing an inventory system, you could help me with some example?

2011/1/28 beto (R3) <bet...@gmail.com>

> Hey guys:
>
> Is there a way to do this query in DAL?
>
> SELECT
>    date, count(foo.items)
> FROM
> (
>    SELECT
>        logs.date, logs.items
>    FROM logs
>    WHERE
>        extract(year from logs.date) = 2010)
>    GROUP BY date, items
> ) AS foo, stock
> WHERE
>    stock.items = foo.items
> GROUP by date
>
> Any help would be appreciated.
>
> thanks!
>



-- 
        Ovidio Marinho Falcao Neto
             ovidio...@gmail.com
         Tecnologia da Informaçao
         Casa Civil do Governador
         83 3214 7885 - 88269088
                  Paraiba