thanks for answers so quickly,
I need to know how I can sum and count the field assoiated by record
more especifically this:
I got several tables associated
ie: client --- buys
name idbuy
idcli idcli
date
and I need to count how many buys got every client but when I put
select
idcli
count(distinct buys.date)
from
client, buys
where
client.idcli=buys.idcli
but it's appear to sum everything and only appear the last record and
the totaly of buys
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
