title: Should I use the sql JOIN keyword for complex joins on multiple tables?
body: <p>I've got the following request :</p>
  
  <pre><code>select * 
      from tbA A, tbB B, tbC C, tbD D
  where 
      A.ID=B.ID and B.ID2= C.ID2 and A.ID=D.ID and C.ID3=D.ID3 and B.ID4=D.ID4
  and
      A.Foo='Foo'
  </code></pre>
  
  <p>I've heard several times that this join syntax is depreciated, and that I should use the 'JOIN' keyword instead.</p>
  
  <p>How do I do that in such a complicated join (multiple tables joined on multiple columns belonging to different tables)? Do you think this best practice still applies here ?</p>