Well the results previously provided where done by another ETL developer and are from a different state. I'm using those results as a guide as how to go forward. I have tried a simple left join but it brings back too many rows and duplicates the actual, begin_balance, and end_balance totals where the district_code is joined instead of providing one line item per. I've also tried to union all the tables with select statements but as you know it just merges the tables together rather than keying on results where the foreign keys match.