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
>