You must include all the fields in the Group by clause

INSERT INTO crsDisclaimer (DiscName, Verbage) ;
	SELECT ;
		web_FundType.DiscName, ;
		web_FundType.Disclos2 AS Verbage ;
		FROM iAccts ;
		JOIN web_FundType ON iAccts.FundTypeId = web_FundType.FundTypeId ;
		GROUP BY web_FundType.DiscName,web_FundType.Disclos2

>Just can't seem to get this to work. I tried to break it up into two statements, but still not getting the results I need. Any help is appreciated.
>
>

>INSERT INTO crsDisclaimer (DiscName, Verbage) ;
>	SELECT ;
>		web_FundType.DiscName, ;
>		web_FundType.Disclos2 AS Verbage ;
>		FROM iAccts ;
>		JOIN web_FundType ON iAccts.FundTypeId = web_FundType.FundTypeId ;
>		GROUP BY web_FundType.DiscName
>