Joining tables for dynamic results?
<p>I'm trying to join these two tables. Let's call one Employees, and the other Employee Information:</p>

<pre><code>Employees
Name         Title         ID
-------      -------     ------
John         Consultant    1
John         Engineer      2
Jane         Accountant    3

Employee Information
Name         EmailAddress    Project
------       -------------   ----------
John         John@work.com    Travelling
John         John1@work.com   Database Maintenance
</code></pre>

<p>I'm trying to join the tables to look like this:</p>

<pre><code>Desired Results
Name      Title       EmailAddress     Project
------    -----       -------------    ----------
John     Consultant   John@work.com    Travelling
John     Engineer     John1@work.com   Database Maintenance
</code></pre>

<p>But I keep getting something like this:</p>

<pre><code>Actual Results
Name      Title       EmailAddress     Project
------    -----       -------------    ----------
John     Consultant   John@work.com    Travelling
John     Engineer     John@work.com    Database Maintenance
John     Consultant   John1@work.com   Travelling
John     Engineer     John1@work.com   Database Maintenance
</code></pre>

<p>I'm running a query similar to this:</p>

<pre><code>SELECT * FROM Employees E INNER JOIN
EmployeeInformation EI ON E.Name = EI.Name
</code></pre>

<p>Looking at it, I can understand why the number of rows doubles, but I can't seem to figure out a way to get the desired output, any suggestions? Or is it not possible since my filters are too vague?</p>