何时使用SQL子查询与标准连接？

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.I am working on rewriting some poorly written S