Explain a SQL query you wrote to combine multiple large datasets and the performance or data-quality issues you encountered.