I need your help with something.
I am Looping a table and reading another so I can work on my conditions and display results.
The problem I have is that one of my conditions consists in the following logic:
If the employee is not found on the results table coming from an external application ( which happens a lot and btw, there is no kee for the employee other than name and last name ) I need to gather the 1st result ( 1st row of the results table ) and get all data but the employee's.
Any solution for this?
I have tried a coupe of things but do not want loop inside the loop for performance reasons.
Help highly appreciated.