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