Explain the difference between a LEFT JOIN, INNER JOIN, and OUTER JOIN, and provide a scenario in healthcare data where you would use each.
