PDA

View Full Version : equivalence between MQL and SQL



jonathansauret
07-10-2008, 05:18 AM
Hi everybody!

I would like to know if it exists an equivalence between MQL and SQL for the clause "IN".
For exemple, i would like to write in MQL the following SQL query :
Select * from table where column1 IN (value1, value2, ...).

What is the syntaxe for the "IN" condition in MQL?

Thank you for your answers.

Jonathan

jonathansauret
07-10-2008, 05:25 AM
I found a Wiki with the pentaho Metadata Formulas!
If someone wants to know, the answer is :
IN([column1];value1,value2,...)

++