Thanks guys. I knew it would be simple (and I should have known it already).
> select a, count(distinct b) from a group by a; > > or if you are checking a specific value of a: > > select count(distinct b) from a where a=10; -- Matthew Jones Hewlett-Packard Ltd Long Down Avenue Stoke Gifford Bristol. BS34 8QZ Tel: +44 (0) 117 312 7490 Email: matthew.jo...@hp.com<mailto:matthew.jo...@hp.com> Hewlett-Packard Limited registered Office: Cain Road, Bracknell, Berks, RG12 1HN. Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users