I have a two tables in my solution , Table Employee which is like a employee master to keep the records of all employees and second table is taskTable which will be used to enter details of new task done by an employee , now I want to check this list from taskTable and want to compare the employee names with the Employee table which has all employees name in it and whoever is missing from the list of Table Employee , i want to send an email reminder to those ..
If I try to list rows first for taskTable and then list rows for Employee table it is not giving the proper output instead it is checking for each value from taskTable to every other value in Employee table and bcoz of that it is returning unexpected results ,
can anyone help please?