Hi,

I use pentaho medataeditor (PME)v5.0.1, to produre my .xmi schema file.
I use this datasource in pentaho report designer (PRD)v5.
In PME, I the RelationShip tools I aggregate (left outer join)[0:1] 2 tables, on "tel_number" and "client_name" is a Condition.
(For info, "client_name", is an input parameter on my report in PRD)
If a use a condition like "client_A", the request, return a result with the "client_A" AND other "client_name" with the null values.
I can see in the sql tool this :
SELECT DISTINCT "tel_number" AS COL0, "name of the client" AS COL1 from table1
LEFT OUTER JOIN table2 ON table1.tel_number = table2.tel_number
AND (table2.client_name="clientA")

My problem, I just want the result with the "client_A", not other "null" values.
In sql language, I will need a "WHERE" condition like this:
SELECT DISTINCT "tel_number" AS COL0, "name of the client" AS COL1 from table1
LEFT OUTER JOIN table2 ON table1.tel_number = table2.tel_number
WHERE table2.client_name="clientA"

How to do that ?
Thank you for the time you spend to me
Best Regards