I am trying to pass multiple values in a SELECT QUERY consisting of two IN clauses. I would like to execute the following query:
String sql = "select ADDRESS from CDR where APARTY in(?,?,?) intersect select ADDRESS from CDR where BPARTY in (?,?) and USAGETYPE='SMSMT'";
How can I pass value using preparedStatement.setString() ?.Thanks in advance.