I know this isn’t rocket science but I learnt a valuable lesson today and thought I should share it. When doing an outer join, particularly a full outer join, make sure that the source tables are already filtered before the…