title: SQL Query to check if joining record exists
body: <p>I have 2 tables - User table (<code>tblUsers</code>) and Logs table (<code>tblLogs</code>).</p>
  
  <p>The User table contains - <code>UserID</code> and <code>UserName</code>.</p>
  
  <p>The Logs table contains - <code>UserID</code>, <code>ApplicationID</code>, <code>ApplicationName</code>, <code>LogonDateTime</code></p>
  
  <p>I want to select all the Users and find if they have accessed a particular application (for example <code>ApplicationID = 3</code>)</p>
  
  <p><strong>Output expected</strong></p>
  
  <pre><code>UserID, UserName, Status
  </code></pre>
  
  <p>Status - If he has visited the <code>applicationID = 3</code> or not.</p>