SQL join combine with condition
<p>Please how to achieve following result from this data?</p>

<p>(I am trying to combine join with conditions but still with some unwanted rows.)</p>

<p>Input is in one table only:</p>

<pre><code>ID    IN    OUT
-----------------
 1    6:00  null
 2    7:11  null
 2    null  16:30
 3    null  19:00
</code></pre>

<p>Output (a view) should combine same IDs so the result will looks like:</p>

<pre><code>ID    IN    OUT
------------------
1     6:00  null
2     7:11  16:30
3     null  19:00
</code></pre>