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.