Hi,

Thank you,
But, I can not make it. My Quary is:

Select IL.Quantidade-Sum(IC.Quantidade)
From ItensLista IL left join ItensComprados IC on
(il.codproduto=ic.codproduto and il.codlista=ic.codlista)
left join Produtos p on (IL.CodProduto=P.CodProduto)
Where il.CodLista = :PARAM
Group by IL.Quantidade

The Table IC have must values with cod. but the table IL Cod is UNIQUE =)
Then I do SUM(Quantidade). Help me please

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, June 27, 2003 4:42 PM
Subject: Re: [firebird-support] Problemas with SUM()


> Hi João,
>
>
> > Hello, =)
> > I am with problems SUM (). My Query returned NULL but my values is 10
and
> > NULL. Why?
>
> 10 + NULL results into NULL.
>
> If you want to exclude NULLs, do:
>
> select sum(mycol)
> from table
> where mycol is not null
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> http://www.upscene.com
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/6/2003