Getting value from a table and add value from table 2 if excist
<p>I'm new to SQL and im wondering if something like this is possible.</p>

<p>It's probably a super simple solution but i cant seem to solve it. I'm using an Oracle database.</p>

<p><code>Employee_Table</code>:<br>
employeeNr <br>
username<br>
address<br>
epost<br></p>

<p><code>Computer_Table</code>:<br>
employeeNr<br>
ComputerNumber<br>
ComputerUpdated<br></p>

<p>When I'm using<br> </p>

<pre><code>SELECT *
From Employee_Table,
     Computer_Table
WHERE Employee_Table.EmployeeNr = Computer_Table.EmployeeNr
  AND Employee_Table.username LIKE ('%SomeUsername%')
</code></pre>

<p>When I'm using this sqlstring I only get users with computers. I would like to get all users and the computers of those who has one. <br>
<br>
Now the million dollar question. What modifications do I need to make? </p>