For one of my other projects I need a piece of code which looks up data between two different DataTables:
First table has:
Request Number Status
123 Pending with XXXX
456 Completed
789 Completed
Second table has:
Request Number Status
123
999
342
At the end of execution, I need to resulting DataTable to look like this:
Request Number Status
123 Pending with XXXX
999 New Request
342 New Request