Hi all!
Shown below are two tables, item and item Category. in item there are 3 item category columns shown id's from item Category. I want to get the names shown instead of the id's. I made a result table aswell want I want to achieve.
I showed a companyid aswell because in the table item Category are only three columns with this as the third column. This obviously links to an third table with company names. I just wanted to give u all the info. Maybe this is not working because of this link?
I tried merge but can't make it work. need some help!
Table: item
| itemL1CategoryId | itemL2CategoryId | itemL3CategoryId | CompanyId |
| 1 | 5 | 8 | 2 |
| 2 | 6 | 3 | 1 |
| 4 | 7 | 5 | 3 |
| 3 | 3 | null | 4 |
| null | null | null | 3 |
| 6 | 4 | 3 | 3 |
Table: item Category
| itemCategoryId | companyID | name |
| 1 | 3 | Electronics |
| 2 | 1 | Computer |
| 3 | 5 | Laptops |
| 4 | 8 | Tablets |
| 5 | 6 | Freezer |
| 6 | 7 | Action camera's |
| 7 | 8 | Kitchen |
| 8 | 1 | Lamps |
| 9 | 3 | Audio |
Wanted Result:
| itemL1CategoryId | itemL2CategoryId | itemL3CategoryId | CompanyId |
| Electronics | Freezer | Lamps | 2 |
| Computer | Action camera's | Laptops | 1 |
| Tablets | Kitchen | Freezer | 3 |
| Laptops | Laptops | null | 4 |
| null | null | null | 3 |
| Action camera's | Tablets | Laptops | 3 |
thanks in advance!
