title: Sql LEFT OUTER JOIN with WHERE clause
body: <p>I have two tables:</p>
  
  <p><strong>Request:</strong></p>
  
  <pre><code> RequestID | Msg
  ----------------
      5  | abc
      6  | def
      7  | ghi
      8  | jkl
  </code></pre>
  
  <p><strong>RequestStatus:</strong></p>
  
  <pre><code>RequestStatusID | RequestID |StatusID
  -------------------------------------
          1             5         1
          2             8         2
  </code></pre>
  
  <ul>
  <li>Not every request has a record in <code>RequestStatus</code></li>
  </ul>
  
  <p>I need all the records from table <code>Request</code> except when <code>StatusID = 2</code>.  (<code>requestID=8</code> should be filter-out)</p>
  
  <p>I am using <code>LEFT OUTER JOIN</code> to recieve the records from table <code>Request</code> but when I am adding Where clause <code>(Where StatusID = 1)</code> of course it does not work.</p>