'Why this error (text and text are incompatible?)

please help,

I am unsure why I keep getting this error 'The data types text and text are incompatible in the equal to operator.'

When I run this code it works;

SELECT  [startername]
        ,[endername]
FROM [master].[dbo].[MATCH]
WHERE enderpoints = 0.0

When I run this code it works;

SELECT name FROM PLAYERS WHERE TEAM like 'Stars' OR TEAM like 'Aces'

When I try to do both I get an error, what am I missing?

SELECT  [startername]
        ,[endername]
FROM [master].[dbo].[MATCH]
WHERE enderpoints = 0.0
AND startername IN (SELECT name FROM PLAYERS WHERE team like 'Stars' OR team like 'Aces')


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source