Kevin,

Can you please try all 4 select sql posted in this thread and post speed results? I'm curious which one is better.

Thanks a lot in advance.

>Great. Thanks Sergey
>
>
>
>>Following query should work too
>>

>>SELECT mh.Caption, mh.Icon, COUNT(mi.Parent ) AS Total;
>>	FROM MenuHead MH;
>>	LEFT JOIN MenuItems mi on mi.Parent = mh.id;
>>	GROUP BY mh.Caption, mh.Icon;
>>	INTO CURSOR Temp1
>>

>>>Forget that. I must have copied & pasted wrong. I did it again and it worked.
>>>
>>>Thanks everyone.