Sender JDBC adapter

Hi All,

I have 2 tables. First table

Header

-

Name EmpId Status

Jai 5601 0

Karthik 5579 0

Item

-

Name Contactnumber

Jai 9894268913

Jai 04312432431

Karthik 98984110335

Karthik 04222643993

Now I need to select a single record from Header and all its corresponding records from Item then I need to update the status field to prevent processing the same record and move to next header and all its corresponding Item records. How can I achieve this in a scenario with out BPM? How should I write my SQL and Update SQL in sender commn channel?

Appreciate your help in this.

Thanks & Regards,

Jai Shankar.