title: LEFT JOIN in Big Query acting as RIGHT JOIN
body: <p>I have been experiencing a strange problem. Sometimes when I am using <code>LEFT JOIN</code> in Big Query e.g in a dummy query like this: </p>
  
  <p><code>select A.id, A.some_col, B.another_col from A LEFT JOIN B ON A.id = B.id</code> </p>
  
  <p>and let's say table A has 10.000 entries and table B has 700 entries, I get 700 entries as a result. <strong>Why doesn't it give me 10.000 entries (where 700 have full B. another_col and the remaining 9.300 have it as <code>NULL</code>)?</strong></p>
  
  <p>Why is this so? It is performing like RIGHT JOIN. Does anybody understand it? What can I do to make it work correctly?</p>
  
  <p>Thanks in advance.</p>