http://weblogs.sqlteam.com/davidm/archive/2004/01/20/748.aspx
DataTable Relational Operators in C# - JOIN Method
This JOIN method is equivalent to the TSQL INNER JOIN expression using equality.
This method returns all columns from both tables.
Once again, column name collision is avoided by appending "_Second" to the columns affected.
DataTable Relational Operators in C# - JOIN Method
This JOIN method is equivalent to the TSQL INNER JOIN expression using equality.
This method returns all columns from both tables.
Once again, column name collision is avoided by appending "_Second" to the columns affected.