Join tables with a common where condition

[uilli]

I have two tables in two different environments. I need to simulate using Kettle a query like the following one:

select *
from t1
left join t2
on t1.a=t2.a
where t1.b="VALUE1" OR t2.c="VALUE2"

I've tried with two table input with the following queries:

select *
from t1
where t1.b="VALUE1"

select *
from t2
where t2.c="VALUE2"

And then merging the data flows, but of course I miss data.

Have you any idea about how to solve this problem?

Thank you!

[johanhammink]

Why are you missing data? With the merge join step you can also use a left join

[uilli]

Sorry, I've modified my query. The where condition contains an OR, not an AND.

[uilli]

Why are you missing data? With the merge join step you can also use a left join

The first table input retrieve the data verifying the first part of the where condition. The second one retrieves the one veryfying the second part. I can perform I left join using the Merg Join step, but I cannot simulate the whole WHERE condition.

In other words, the first table input retrieves from t1 just a subset of the data I need, the ones satisfying t1.b="VALUE1", but doesn't the ones satisfying t2.b="VALUE2".

[Ana GH]

Use the filter step in a transformation to set up the WHERE with an OR condition.