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

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