Hi Everyone,
I am a noob so please be patient with me! My query needs to show weekly sales and targets by store and product class. I need to show all stores whether or not it has a target. My sales table will not have an entry if a store/week/class combo does not exist (i.e. Instead of a sale of $0). My Target table similarly has entries for which there are targets but not every store.
Problem
An outer join on either presents a problem. I cannot left Join on Sales because there is no entry for that store/class if its $0 sales. I cannot left join on Targets because it will eliminate all stores on the output for which there are no targets.
Possible Solution?
It seems I would have to create a placeholder of $0 entries for every week/store/class combo in my Target table. I am scrapping this together from ill-formatted spreadsheets (always fun!). Is this reasonable?