cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abaak Frequent Visitor
Frequent Visitor

Want to show names instead of id numbers in table 1

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

itemL1CategoryIditemL2CategoryIditemL3CategoryIdCompanyId
1582
2631
4753
33null4
null nullnull3
6433

 

Table: item Category

itemCategoryIdcompanyIDname
13Electronics
21Computer
35Laptops
48Tablets
56Freezer
67Action camera's
78Kitchen
81Lamps
93Audio

 

Wanted Result:

itemL1CategoryIditemL2CategoryIditemL3CategoryIdCompanyId
ElectronicsFreezerLamps2
ComputerAction camera'sLaptops1
TabletsKitchenFreezer3
LaptopsLaptopsnull4
null nullnull3
Action camera'sTabletsLaptops3

 

thanks in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
chirayuw Member
Member

Re: Want to show names instead of id numbers in table 1

1 REPLY 1
Highlighted
chirayuw Member
Member

Re: Want to show names instead of id numbers in table 1