Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
"Select * from table1" +context.filename
"Select * from table1where col3 in (val1,val2, val3)"
String select = "Select column1, column2, column3 From table1 ";
String where = "";
if(row1.value.compareToIgnoreCase("test")==0){
where = "Where column1 = '"+row1.data+"'"
}
String query = select+where;
System.out.println(query);
"SELECT
COLUMN1,
COLUMN2,
COLUMN3
FROM TABLE
WHERE COLUMN1 = " +context.YourContext
Instead of building a "WHERE col1 IN" clause with your list of unmatched values, why not insert them into a table and join it to your my_table?