title: When to use SQL sub-queries versus a standard join?
body: <p>I am working on rewriting some poorly written SQL queries and they are over-utilizing sub-queries. I am looking for best-practices regarding the use of sub-queries.</p>
  
  <p>Any help would be appreciated.</p>