title: SQL - Select rows from two different tables
body: <p>Having this table</p>
  
  <pre><code>Table "Items"
  
  itemID
  itemTitle
  itemContent
  </code></pre>
  
  <p>and this</p>
  
  <pre><code>Table "MyList"
  
  userID
  itemID
  deleted
  </code></pre>
  
  <p>how can I select all rows from table "Items" and showing the field "deleted", even if the itemID do not exist in "MyList", given an userID?</p>
  
  <p>Example of the query result:</p>
  
  <pre><code>itemID | itemTitle | deleted | userID
  -------------------------------------
  1      | Title1    | 1       | 2
  2      | Title2    | 0       | 2
  3      | Title3    | (null)  | (null)
  4      | Title4    | (null)  | (null)
  </code></pre>
  
  <p>What would be the query, so that I can get that result?</p>
  
  <p>Thanks</p>