>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.