Joining two subqueries or a query with a subquery SQL Server 2008 ...

Joining two subqueries or a query with a subquery SQL Server 2008 .... 0)), totalVisits = MAX(y.c) FROM y LEFT OUTER JOIN z ON y.

stackoverflow.com