>>I would rather use additional query to create a reporting cursor by joining the tables and filtering out records
>>
>
>Noted sir. Will redo my code, I just thought that execution is faster than retrieving a JOIN with repeating fields.
>

I don't think it'll make any difference with the # of records you process.