| Subject | Re: [firebird-support] Re: Problem with LEFT OUTER JOIN and COUNT() |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-04-10T13:53:41Z |
At 11:47 PM 10/04/2006, you wrote:
./heLen
>So simple ^^True; and DISTINCT never counts nulls.
>
>Thanx a lot man, this did the trick:
>
>SELECT COUNT(DISTINCT N.CUPOM)
>
>Cause N.CUPOM is my primary key, and thats all that matters :)
./heLen