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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users