You need two queries
Start with your query 117 then make a new query with Data table & query 117
Code:
SELECT [117].LinName, [117].LIN, [117].ChanUID, [117].Parent, Data.Parent AS B286Parent
FROM 117 INNER JOIN Data ON [117].Parent = Data.Unique;
Code:
LinName |
LIN |
ChanUID |
Parent |
B286Parent |
155 Mtd |
B286 |
12313 |
12311 |
11321 |
155 Mtd |
B286 |
12314 |
12311 |
11321 |
155 Mtd |
B286 |
12315 |
12312 |
11321 |
155 Mtd |
B286 |
12316 |
12312 |
11321 |
155 Mtd |
B286 |
12317 |
12319 |
12321 |
155 Mtd |
B286 |
12318 |
12320 |
12321 |
CH1 |
B840 |
12321 |
12313 |
12311 |
CH1 |
B840 |
12322 |
12314 |
12311 |
CH1 |
B840 |
12323 |
12315 |
12312 |
CH1 |
B840 |
12334 |
12316 |
12312 |
CH1 |
B840 |
12335 |
12317 |
12319 |
CH1 |
B840 |
12336 |
12318 |
12320 |
CH2 |
B841 |
12337 |
12313 |
12311 |
CH2 |
B841 |
12338 |
12314 |
12311 |
CH2 |
B841 |
12339 |
12315 |
12312 |
CH2 |
B841 |
12340 |
12316 |
12312 |
CH2 |
B841 |
12341 |
12317 |
12319 |
CH2 |
B841 |
12342 |
12318 |
12320 |