This post is really about performance. I had a situation where I started off using subqueries: SELECT DISTINCT Account.Name AS BusinessName, Test.New_name AS TestName, (SELECT COUNT(*) FROM New_Test T2 WHERE T2.New_AccountId = Account.AccountId AND T2.new_testtypeid = Test.new_testtypeid AND new_result...