I am trying to merge table data with cursor data. I have the following scenario
Cusror has a row number and i need to join with table data to retreive the ID from tbl1
Insert the tbl1 ID into table with rest of cursor data.
Does anyone know how I can achieve?