(Steve Endow) For the past several years, I’ve noticed that I have generally avoided using subqueries, based on a suspicion that they are probably less efficient than a JOIN.
/membership]
Read More (Community content)
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help