How to write in clause on where condition for a sql

0

I have a query like this 

SELECT * FROM CATEGORY  CAT WHERE   CAT.CAT_CAT_NO  =$P{employerRefNumber} 

Now I want to pass in cluse in where condition like

SELECT * FROM CATEGORY  CAT WHERE   CAT.CAT_CAT_NO  in ($P{employerRefNumber} )

value of employerRefNumber should be 'C001','C002' like this.

Kindly guide me proper sysntex of this query in jasper report

 

 

das.sujit1's picture
Joined: Sep 10 2021 - 11:33pm
Last seen: 1 day 21 hours ago

1 Answer:

0
gustavofarias's picture
Joined: May 22 2012 - 7:10am
Last seen: 1 day 11 hours ago
Feedback