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