title: SQL Server NULL value with inner join
body: <p>I am using C# and SQL Server.</p>
  
  <p>Take a look at the following SQL:</p>
  
  <pre><code>SELECT table1.id, table1.description, table2.name, table2.surname 
  FROM table1 
      INNER JOIN table2 ON table1.EmpID = table2.EmpID
  </code></pre>
  
  <p>It is straight forward and works fine. It retrieves the data from table1 table just fine and inner joins <code>table1.empid</code> to <code>table2.name</code> and <code>table2.surname</code> correctly.</p>
  
  <p>Now, sometimes <code>table1.empid</code> is null and when it is, this SQL just ignores the "row" with the null value; which is pretty normal basing on the criteria.</p>
  
  <p>What I need here is to also get the "rows" with the null values and when <code>table1.empid</code> is null I need to set a custom value to <code>table2.name</code> and <code>table2.surname</code>.</p>
  
  <p>I have been playing with isnull() but all I did is make it even worst.</p>
  
  <p>Any suggestions?</p>
  
  <p>Thanks</p>