title: left Join old syntax migration
body: <p>I have to migrate an old SQL Statement to SQLServer2008. The old SQL-Statement still has the old Join-Operator "*=". Of course I could set the DB-Compatibility, but I don't like to do this :-)</p>
  
  <p>My Question: I am not sure if I am doing following correct and I can't test the old statement anymore. Could someone please check the syntax of my new SQL-Statement ?</p>
  
  <p>old original statement :</p>
  
  <pre><code>select * from A,B where A.field *= B.field
  </code></pre>
  
  <p>My guess:</p>
  
  <pre><code>SELECT * from A
  LEFT JOIN B
  ON A.field=B.field;
  </code></pre>
  
  <p>Or is it the opposit way ? :</p>
  
  <pre><code>SELECT * from B
  LEFT JOIN A
  ON B.field=A.field;
  </code></pre>
  
  <p>Thanks and regards</p>