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

Thanks everyone.





>It gives me
>"Function name is missing )."
>
>
>
>>Try
>>

>>SELECT mh.Caption, mh.Icon, ;
>>          (SELECT COUNT(*) FROM MenuItems mi WHERE mi.Parent = mh.id) AS Total ;
>>	FROM MenuHead MH;
>>	INTO CURSOR Temp1
>>

>>
>>>I have a header table and a child table.
>>>
>>>Not all header records have a child record.
>>>
>>>I want to pull all headers and also a column with the count of child records.
>>>
>>>What I have isn't working. Using VFP 9:
>>>
>>>

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

>>>
>>>Anyone?
>>>
>>>Thanks