dj1202 (8/6/2012)
After further review, I believe I understand your recommendation now. Are you suggesting that I input NULL or 0 values in the table, for all the location groups that currently do not have a value?
Yes, you need to artificially add rows with missing location groups to your dataset and set all other columns in those rows to NULL, blank, 0, or whatever default value you see fit.
Left Join that Jared suggested is probably the best way to do this.
--Vadim R.