连接到同一个表两次，在第一个连接条件中匹配出发站，在第二个连接条件中匹配到达站：

SELECT t.id,
       d.actualid AS actualdepartureid,
       a.actualid AS actualarrivalid
FROM   table1 t
       INNER JOIN stationTable d
       ON t.stationdepartureid = d.stationid
       INNER JOIN stationTable a
       ON t.stationarrivalid = a.stationid

• （注意：如果您的要求满足，您可以将INNER JOIN更改为LEFT OUTER JOIN。）*

或者你可以使用相关的子查询：

SELECT t.id,
       (SELECT d.actualid FROM stationTable d WHERE t.stationdepartureid = d.stationid)
         AS actualdepartureid,
       (SELECT a.actualid FROM stationTable a WHERE t.stationarrivalid = a.stationid)
         AS actualarrivalid
FROM   table1 t

其中，对于样本数据：

CREATE TABLE Table1 (Id, StationDepartureId, StationArrivalID) AS
SELECT 8, 10001, 10002 FROM DUAL;

CREATE TABLE stationTable (Id, StationId, ActualID) AS
SELECT 1, 10001, 11111 FROM DUAL UNION ALL
SELECT 2, 10002, 22222 FROM DUAL;

两个输出：
| ID|实际部门ID|实际有效|
| --|--|--|
| 8 | 11111 | 22222 |
fiddle