COGNOiSe.com - The IBM Cognos Community

Hello All:

I have a multi select prompt and I can use that parameter in the query with IN clause..

I know that IN clause is multiple OR stmts.

Can we make it as multiple AND stmts.

I'm guessing that there's a reason that's not an option.  It won't work.

Consider TableA:

id	val
1	a
2	b
3	c

select *
from TableA
where val = 'c'
  and val = 'b'
would return 0 rows.