Missing comma after subquery and the subquery doesnt have a SELECT clause.

SELECT

fld1

,fld2

,(SELECT max(something) from dbo.somewhere) as MaxOfSomething

,fld3

FROM dbo.SomewhereElse