I am doing an inventory system, you could help me with some example?
2011/1/28 beto (R3) <[email protected]>
> 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
[email protected]
Tecnologia da Informaçao
Casa Civil do Governador
83 3214 7885 - 88269088
Paraiba
