How can join two datatable and find a row according to a condition like using SQL statement query?

@ngocvk
with a LINQ statement have a look here

was done for List but even can be done for Datatable using column for the join condition.
like Isolate multiple rows with duplicate column values - #18 by ppr

Specific statement can we provide if needed