Joining two DataTables in C# with non matching data
===

I have two tables in SQL that I populate into DataTables in C#. They SQL tables are housed on different servers and different DB's.

In the first table I have 5 columns

    Name(string), AgentStatus(string), TimeInState(double), TaskHandled(double), Region(string)

The second table I have 3 columns

    Name(string), CChats(double), AChats(double)

I have been using this link to merge the tables in C# 

http://stackoverflow.com/questions/665754/inner-join-of-datatables-in-c-sharp

However the issue I am having is this.

Table 1 has 59 rows, 1 for each user.

Table 2 has 25 rows, 2 for each user that has a Chat account.

When I merge them in C# I only get the matches from table 1 that match the 25 rows in table 2. I need to show all rows from table1 and if they have a row in table 2 show that data, otherwise display 0's

I know where the issue is, its in the select statement in the link above, but I am not sure how to fix it in C#