If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multi select prompt question

Started by nandamuri, 01 May 2024 02:18:17 PM

Previous topic - Next topic

nandamuri

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.


dougp

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

Consider TableA:

idval
1a
2b
3c

select *
from TableA
where val = 'c'
  and val = 'b'

would return 0 rows.