I have an Application table which holds information about an application. I have a ApplicationCompany table which identifies the state that the application operates in, as well as other information such as ItemCount and UnitCount.
The Application may or may not apply to all possible states, which is held in the Company table.
AppID State Items Units
1 AR 2 209
1 AK 1 100
2 AK 10 90
I am hoping to arrive at:
ApplicationName ApplicationDescription State Items Units State Items Units
Test Test Application AR 2 209 AK 1 100
Test2 AK 10 90