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
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people