HELP for 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 each member1 meets any 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 member1 if member1 e.g. A
meets none (0) member2 when XX is e.g. 40.

Any help is appreciated!
Thank you!

Ralf Received on Fri May 31 2002 - 02:29:29 CDT