You are not logged in.
Hello, I'm new to Talend,
I have 2 tables: table1, table2
For each row of table1, I need to know if table1.attribute1 has a corrispondent value in table2.attribute2.
After that I need to update table1.attribute3 with value 'Y'.
Anyone can suggest me how to do it?
Thanks in advance.
What database are you using? You could do this entirely within the db using a t<db>Row component, but the syntax varies slightly based on the database.
"UPDATE table1, table2
SET table1.attribute3 = 'Y'
WHERE table1.attribute1 = table2.attribute2"
and if the two tables were in different databases?