Explain the difference between INNER JOIN, LEFT JOIN, and OUTER JOIN with practical testing scenarios.
