Join two data tables and if column values matched ,need to get column values from right table

Hi , I need to compare “name” and “class” in two data tables, if rows are matched just need to merge “head” and “count” columns into dt1.(Note: “” field is not a primary key)


Hope the following sample helps you. (15.3 KB)