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, DetTemp;
    INNER JOIN ON LineTemp.BoId = DetTemp.BoIdBase ;
    WHERE NOT EMPTY(AirTime) AND ;
      RecType = "A" ;
    GROUP BY BoIdBase ;
    INTO CURSOR DetTemp