title: How to convert old SQL?
body: <p>I am converting deprecated SQL (*=) to Left Join.  Are the following SQL statements equivalent?  Will performance be improved?</p>
  
  <p><strong>OLD</strong></p>
  
  <pre><code>SELECT n.name, 
     n.address, 
     e.email, 
     e.title,
     m.car,
     l.type      
    FROM name n, 
     employee e, 
     miscellaneous m,
     lifestyle l      
   WHERE n.id = 3 
   AND n.id = e.id   
   AND n.id *= m.id 
   AND n.id *= l.id; 
  </code></pre>
  
  <p><strong>NEW</strong></p>
  
  <pre><code>SELECT n.name, 
     n.address, 
     e.email, 
     e.title,
     m.car,
     l.type      
    FROM name n, 
     employee e, 
     miscellaneous m,
     lifestyle l
  Inner Join empId ON n.id = e.id  
  Left Join miscId ON n.id = m.id    
  Left Join lifeId ON n.id = l.id;
  </code></pre>