Reply
Frequent Visitor
Posts: 7
Registered: ‎04-12-2018
Accepted Solution

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!

 


Accepted Solutions
Highlighted
Member
Posts: 65
Registered: ‎10-03-2018

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


All Replies
Highlighted
Member
Posts: 65
Registered: ‎10-03-2018

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