For all entries - not giving duplictaes
The for all entries is not retrieving duplicates.I need to include all selections.Any other way to do this other than including then select in loop or giving all pkeys....
I think you can do in one other way. Once you have obtained the records of the first table, collect all the field values which you will be requiring in ranges and then use this ranges to select from the 2nd table. i.e if you are using two fields of the 1st table in the where clause of the 2nd table, then collect all the values of these two fields in two range tables and then use it for selection from 2nd table.
Hope this will solve your issue.