e's a way. The queries I have tried either give me all members in all
groups, or only records where Jim is a member. My closest query follows,
then a sketch of my tables with a results set at the end. Can someone
please tell me where I an blowing it?
Thanks -
Dan Hansen
SELECT group
I ended up stopping and restarting MySQL -- which cleared up the
problem. Index creation took around a minute.
Dan
At 05:38 PM 10/15/03, Matt W wrote:
Hi Dan,
133MHz huh? :-) Well, how large is the table? Huge rows? How many other
indexes are on the table and on how many columns? Are those colu
+--+-+---+--+
> .
> .
> .
> | Idaho | NULL| NULL | NULL |
> | Illinois | Test Group | 60070 | Prospect Heights |
> | Indiana | NULL| NULL | NULL |
> .
> .
> .
> etc...
>
&g
