SQL Query to check if joining record exists
<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>