Since you can't use group by without including all non-aggregate fields in the group by clause, there really isn't a way to do it. But as long as you don't care what the values are of transtype, ibucketid, planid, emp_id, and contrib_dt in the final grouping, you could just aggregate them - ie - Max(transtype), Max(iBucketId) etc.

>How can I make the following SQL work under VFP8 without using the SetEngineBehavior command?
>
>

>		INSERT INTO tAcctCont ;
>			(;
>			iTransact, ;
>			transtype, ;
>			Acct_ID, ;
>			econ, ;
>			emat, ;
>			nprofits, ;
>			erforfeit, ;
>			vesteddist, ;
>			othforfeit, ;
>			nprofitsvd, ;
>			totdistrib, ;
>			ibucketid, ;
>			planid, ;
>			empid, ;
>			contrib_dt ;
>			) ;
>			SELECT ;
>			iTransact, ;
>			transtype, ;
>			Acct_ID, ;
>			SUM(econ) AS econ, ;
>			SUM(emat) AS emat, ;
>			SUM(nprofits) AS nprofits, ;
>			SUM(erforfeit) AS erforfeit, ;
>			SUM(vesteddist) AS vesteddist, ;
>			SUM(othforfeit) AS othforfeit, ;
>			SUM(nprofitsvd) AS nprofitsvd, ;
>			SUM(totdistrib) AS totdistrib, ;
>			ibucketid, ;
>			planid, ;
>			empid, ;
>			contrib_dt ;
>			FROM tAcctContTEMP ;
>			GROUP BY 1, 3
>