Using 'IN' Operator In Query

I have the following query:



select * from

(

select FLATTENED NODE_CAPTION,



(SELECT

[PROBABILITY],

[ATTRIBUTE_NAME]

FROM

NODE_DISTRIBUTION

WHERE

(

ATTRIBUTE_NAME ='Product A'

and

ATTRIBUTE_VALUE='Existing')

and [PROBABILITY] > 0.5

) as probabilidad

FROM [Cluster XYZ].CONTENT) as T

where T.[probabilidad.PROBABILITY] > 0

and T.[probabilidad.PROBABILITY] <> 1

order by T.[probabilidad.PROBABILITY] DESC


I need to add more products (more Attribute_Name) to the query. I tried to use an 'IN' operator, but I received an error.

I need something like:

ATTRIBUTE_NAME in ('Product A', 'Product B','Product C')

Thanks for your help!