Why am I getting a T-SQL error near the SELECT verb?

SQLServerCentral » Latest topics

Why am I getting a T-SQL error near the SELECT verb?

INSERT INTO  dbo.mixedwords (Mixed, MixLen, GoodVa)
Values ( SELECT DISTINCT LTRIM(RTRim(mixVa) as NewTerm
                            , MixCnt 
    &nbs

more info...