Skip to Content
0
May 29, 2013 at 07:33 AM

Multiple values for where condition in Query template

5117 Views

Hi All,

How to pass multiple or more than one values for [Param.1] in fixed query.

For exapmle, My query is like this,

In MII

SELECT * FROM Customers

WHERE City IN '[Param.1]'

In SQL

SELECT * FROM Customers

WHERE City IN ('Paris','London');

In SQL, the above mentioned query is working fine, but same is not working in MII. Please anyone let me know what I am missing ?

Regards,

Aravinth