I have two sample tables like below
Table 1:
company code | Fields | Key1 |
AA | Management total | 1 |
AA | staff total | 2 |
AB | Management total | 1 |
AB | staff total | 2 |
Table 2:
Company code | Attributed fields | key 2 |
AA | Manager | 1 |
AA | CIO | 1 |
AA | IT Staff | 2 |
AA | Dev Staff | 2 |
AB | Manager | 1 |
AB | CIO | 1 |
AB | IT Staff | 2 |
AB | Dev Staff | 2 |
these tables are already joined by the primary Key company code, now I want to associate them based on Key 1 and Key 2