title: Oracle and SQL Server select (+) equivalent
body: <p>In Oracle I have:</p>
  
  <pre><code>SELECT t2.Regkood, t2.naitatel, t2.naitafaks, t3.lahtiolekuaeg, t1.*
  FROM table1 t1, table2 t2, table3 t3
  WHERE t1.client = t2.client AND t1.client = t3.client(+) AND t1.client = 414246
  </code></pre>
  
  <p>How do I get the same in SQL Server?</p>
  
  <p>thanks</p>