By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create Table Table1(ID1 VARCHAR(50), ID2 VARCHAR(50), ID3 VARCHAR(50));
Insert Into Table1 Values('A1',null,null),
(null,'B2',null),
(null,'C3',null),
(null,null,'D4'),
(null,null,'E5');
Create Table Table2(ID VARCHAR(50), Trips INT);
Insert Into Table2 Values('A1',50),
('B2',21),
('C3',35),
('D4',12),
('E5',35);
Records: 5 Duplicates: 0 Warnings: 0
Records: 5 Duplicates: 0 Warnings: 0
SELECT T.ID1, T.ID2, T.ID3, D.Trips
FROM Table1 T JOIN Table2 D
ON D.ID IN (T.ID1, T.ID2, T.ID3)
ORDER BY COALESCE(T.ID1, T.ID2, T.ID3)
| ID1 | ID2 | ID3 | Trips |
|---|---|---|---|
| A1 | null | null | 50 |
| null | B2 | null | 21 |
| null | C3 | null | 35 |
| null | null | D4 | 12 |
| null | null | E5 | 35 |