title: Simulate a left join without using "left join"
body: <p>I need to simulate the left join effect without using the "left join" key.</p>
  
  <p>I have two tables, A and B, both with <code>id</code> and <code>name</code> columns. I would like to select all the dbids on both tables, where the name in A equals the name in B.</p>
  
  <p>I use this to make a synchronization, so at the beginning B is empty (so I will have couples with id from A with a value and id from B is null). Later I will have a mix of couples with value - value and value - null.</p>
  
  <p>Normally it would be:</p>
  
  <pre><code>SELECT A.id, B.id
  FROM A left join B
  ON A.name = B.name
  </code></pre>
  
  <p>The problem is that I can't use the <code>left join</code> and wanted to know if/how it is possible to do the same thing.</p>