Resolving Subquery Issues: A Practical Guide to Using Left Outer Joins in SQL