select point, pid, [value]
from ValInt
where ( pid, point )
in
( 
    select ValInt.pid, max( ValInt.point)
    from ValInt join points on ValInt.point = points.point and points.uid = 46 
    where ValInt.point < 100000
    and ValInt.pid in (20,145,555,9834,876235)
    group by ValInt.pid 
)

Line 3: Incorrect syntax near ','.