I have DTa and DTb
DTa is consist of:-
Supplier_Code / Supplier / PO_Number / Description / Date
DTb is consists of
Supplier_Code / Supplier / Email
I’d like to append Email in DTb to DTa as per the list of Supplier_Code in DTa
DTa has a list of Supplier_Code
DTb has a list of Supplier_Code
I only need email contacts of A,D,H.
I tried to use Join Data Table with a condition when Column 0 in DTa is same as Column 0 in DTb.
But this doesn’t work as the result doesn’t even show Email data.
What is the easiest and shortest way to make this work without building another Data table?