title: Am I translating Ansi OUTER JOIN syntax correctly to older Sybase (*=) join syntax?
body: <p>Assuming this is the correct <strong>Ansi</strong> SQL syntax for a <strong>left outer join</strong>:</p>
  
  <pre><code>SELECT *  
  FROM   employee  LEFT OUTER JOIN department  
            ON employee.DepartmentID = department.DepartmentID
  </code></pre>
  
  <p>And this is the correct <strong>Ansi</strong> SQL syntax for a <strong>right outer join</strong>:</p>
  
  <pre><code>SELECT * 
  FROM   employee RIGHT OUTER JOIN department 
            ON employee.DepartmentID = department.DepartmentID
  </code></pre>
  
  <p>Is this the older <strong>Sybase</strong> equivalent of a <strong>left outer join</strong>:</p>
  
  <pre><code>SELECT * FROM employee, department
  WHERE employee.DepartmentID *= department.DepartmentID
  </code></pre>
  
  <p>And this the older <strong>Sybase</strong> equivalent of a <strong>right outer join</strong>:</p>
  
  <pre><code>SELECT * FROM employee, department
  WHERE employee.DepartmentID =* department.DepartmentID
  </code></pre>
  
  <p>So we put the * on the left side of the equals sign for a left outer join and on the right side of the equals sign for a right outer join.</p>
  
  <p>Is that correct?</p>