Re: [SQL] Cross joining table with itself

2003-09-21 Thread Bruno Wolff III
On Sun, Sep 21, 2003 at 14:38:23 +, Bob Hutzel <[EMAIL PROTECTED]> wrote: > I've been stumped trying to solve this problem via SQL. I have a table ID, > member1, member2, member3. In any row, any member field may have a value > or be null. I want to tally up how many times each member appears

[SQL] Cross joining table with itself

2003-09-21 Thread Bob Hutzel
I've been stumped trying to solve this problem via SQL. I have a table ID, member1, member2, member3. In any row, any member field may have a value or be null. I want to tally up how many times each member appears in the table as a whole. For example, if two entries were ('a', '', 'c') and ('b', 'c