How to write a query with NULL for missing values : <p>Below, I have 2 tables.  I want to write a query that will return each <code>NAME</code> and the corresponding <code>UIN</code> value.  If there is no <code>UIN</code> value, I want to return <code>NULL</code> for that entry instead</p>

<p><a href="https://i.stack.imgur.com/Do7pg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Do7pg.png" alt="enter image description here"></a></p>

<p>For example, 2 entries should be like this for Samanta should be:</p>

<p><code>Bob 49638-001</code></p>

<p><code>Samantha NULL</code></p>

<p>I've tried <code>SELECT NAME JOIN EMPLOYEE_UIN.UIN INSERT "NULL" WHERE UIN = NULL</code> but no luck.  I'm a beginner with SQL and I couldn't find a similar example on SO about this.</p>
