Improving SQL Queries: Using LEFT OUTER JOIN to Fetch Data from Multiple Tables Based on Conditions

Combining SQL Queries: A Single Query Approach Using UNION All