ORA-00904：“纪律”.“SPORT_NO”：无效标识符

Question

select 
  sport_name
from 
  GAMES.sport
where 
  sport.sport_no = discipline.SPORT_NO;

请帮助，表和列确实存在于我的数据库中

Answer 1

尝尝这个

SELECT
      SPORT_NAME
FROM
      GAMES.SPORT,
      GAMES.DISCIPLINE
WHERE
      SPORT.SPORT_NO = DISCIPLINE.SPORT_NO;

Answer 2

select 
  sport_name
from 
  SPORT
  inner join 
     DISCIPLINE
        on SPORT.sport_no = DISCIPLINE.SPORT_NO;  

SPORT.sport_no是SPORT表的主键。

和

DISCIPLINE.SPORT_NO是DISCIPLINE表中的外键