delete records with subquery

[Anonymous]

I have two tables in two databases (MYSQL & SQL*Server)

I would like to implement, with talend, the following query:

delete from T1 where T1.key in (select t2.key from T2 where T1.key=T2.key and T1.date<T2.date)

is it possible ?

If yes how?

Thanks

Didier

[Anonymous]

Using a tMap to a join between T1 and T2 to get the t2.key, if there exist multiple keys, denomalize all the keys to one line after tMap, write the delete query in a tXXXRow component. eg:
tMysqlInput--main--tMap--main--tDenormalize--main(row2)--tFlowToIterate--iterate--tMssqlRow
                               |
                          lookup 
                              |
                      tMssqlInput

on tMssqlRow, you can write the query as below:

"delete from T1 where T1.key in  "+(String)globalMap.get("row2.columnName")