Which Should You UseSQL Server Joins or Subqueries
Which Should You Use–SQL Server Joins or Subqueries By: ... Writing the SELECT statement using the join operator is often easier to read and understand and can also help the SQL Server Database Engine to find a more efficient strategy for retrieving the appropriate data. ... because you would have to write the aggregate function in the WHERE ...