group by

I have the following table

member1	member2	value
A	B	10
A	C	11
A	L	9
A	F	2
B	K	10
B	O	11

I want to count how often member1 meets member2 given that value is larger that XX
this works fine with

select member1, count(member2) from table where value<XX group by member1 ;

The problem is that I also want to see in the result if member1 e.g. A meets zero (0) member2 when
XX is e.g. 40.

Any help is appreciated!
Thank you!

Ralf Received on Fri May 31 2002 - 01:23:38 CDT