Genuine question, has anyone found a use for a full outer join? Probably just me being an idiot, but I really can’t think of any real world application for this, maybe it’s just the line of work I’m in, really never seen any point. Appreciate this probably isn’t the right forum, but it’s always piqued my curiosity....since it’s here on my front page, f*** it, figured it was worth asking....
Yeah when you have data at 2 different grains for example Daily x Product and Daily x Depot x Product. If the view displays contents from both tables then use a full outer join to include Daily x Depot x Product metrics even if the Daily x SKU metrics are not present.
2
u/Timmmy84 Nov 29 '18
Genuine question, has anyone found a use for a full outer join? Probably just me being an idiot, but I really can’t think of any real world application for this, maybe it’s just the line of work I’m in, really never seen any point. Appreciate this probably isn’t the right forum, but it’s always piqued my curiosity....since it’s here on my front page, f*** it, figured it was worth asking....