I need some suggestions on the following scenario
Updation of a flag in a table where the column names in the WHERE clause are from two different tables in the same database.
Set T1.flag =1
where T1.columnA=value1 and T2.columnB=value2
where T1 and T2 are two different tables in the same database,
I want to accomplish this directly using UPDATE in JDBC receiver by using JOIN query in the structure.