Skip to Content
Former Member
Aug 13, 2007 at 05:20 AM

using select query to insert into a field



I am working with a jdbc-to-jdbc scenario, in which on source side iam geting data from 2 tables t1 & t2 and inserting this data into two tables tb1 & tb2 on target side.A field in tb2 has to be inserted with a value which is equal to the number of records inserted into the table tb1 i.e with the number equal to 'how many records from the table t1 has been retrieved inorder to insert into table tb1'.

Can anybody please suggest me.....

Thanks & Regards,