How to acheive this <= join condition in tjoin or tmap component

[venkatadilip]

Hi,

I have this query

select TBL1.*

from TBL1,

TBL2

inner join 

ON trim(TBL1.ROWID)=trim(TBL2.ROWID)

CAST(CAST(TBL2.CREATE_DATE AS TIMESTAMP) as DATE)<=CAST(CAST(TBL1.CREATE_DATE AS TIMESTAMP) as DATE)

which needs to be translated into Talend job.

first join condition (

trim(TBL1.ROWID)=trim(TBL2.ROWID)) is not a problem to achieve

but how to implement the second join condition CAST(CAST(TBL2.CREATE_DATE AS TIMESTAMP) as DATE)<=CAST(CAST(TBL1.CREATE_DATE AS TIMESTAMP) as DATE) is what i need help with...

How to translate the second joining condition in Talend??

[manodwhb · Accepted solution]

You need do cross join and then in tMap output section enable filter with that condition. ​

[venkatadilip]

Thank you @Manohar B​