See corrections below in bold

>What's wrong here?
>
>The first SQL works fine. I get totals for all records, grouped
>on the BoIdBase field.
>
>I want to add those counts as a new column into the LineTemp table,
>which has an Id equivilent to BoIdBase called BoId.
>
>  SELECT COUNT(DocId) AS Cleared, BoIdBase ;
>    FROM Details ;
>    WHERE NOT EMPTY(AirTime) AND ;
>      RecType = "A" ;
>    GROUP BY BoIdBase ;
>    INTO CURSOR DetTemp
>
>
>  SELECT LineTemp.*, DetTemp.*;
>    FROM LineTemp;
>    INNER JOIN DetTemp ON LineTemp.BoId = DetTemp.BoIdBase ;
>    WHERE NOT EMPTY(AirTime) AND ;
>      RecType = "A" ;
>    GROUP BY BoIdBase ;
>    INTO CURSOR LineDetTemp
>