Skip to Content
0
Former Member
Jul 13, 2006 at 11:54 AM

Joins implementation receiver Jdbc Adapter

10 Views

Hi All

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.

i.e

UPDATE T1

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.

kindly reply

thanks

sd