Explain the difference between a join and a subquery, and when you would use each to troubleshoot a reporting error.
