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.