title: What means "table A left outer join table B ON TRUE"?
body: <p>I know conditions are used in table joining. But I met a specific situation and the SQL codes writes like "<code>Table A join table B ON TRUE</code>"</p>
  
  <p>What will happen based on the "ON TRUE" condition? Is that just a total cross join without any condition selection?</p>
  
  <p>Actually, the original expression is like:</p>
  
  <pre><code>Table A LEFT outer join table B on TRUE
  </code></pre>
  
  <p>Let's say A has m rows and B has n rows. Is there any conflict between "left outer join" and "on true"? Because it seems "on true" results a cross join.</p>
  
  <p>From what I guess, the result will be m*n rows. So, it has no need to write "left outer join", just a "join" will give the same output, right?</p>