I'm try to merge 2 queries with sales by customer in differnet years. I tried to turn the merge to "full outer" hoping to capture the customer who didn't have sales in 2020 but did have sales in 2021. However the output of the merge shows (null) for customer 5 and 7. Is there a way to merge the two tables so I have 2 distinct columns for sales by year and all distinct customers? Thanks.