@chiashin Ok here is an example using MySQL with the syntax created like this using group by and string manipulation:
SELECT * FROM (SELECT * FROM `db_knime`.`my_table_00`
) AS `table`
WHERE `ID` IN ('AA12345', 'DD12456')
AND `SOMENUMBER` IN (21, 3, 6)
The string values are enclosed in single quotes and are concatenated thru group by node.
kn_example_db_mysql_where_clause.knwf (76.0 KB)