in an earlier thread, the following query was submitted:
SELECT COUNT(*) FROM q
and as part of his answer, David Johnson responded
3. Also, you are using a correlated sub-query instead of a LEFT OUTER JOIN
This interests me. How would you rewrite the correlated subquery above
using the outer join?