sql - oracle中的列部分不能有量词

Question

嗨，我有一个架构，正在尝试获取不同的学生 ID 我写的 sql 是有道理的，但 Oracle 说

ERROR at line 1:
ORA-25154: column part of USING clause cannot have qualifier

我写的sql是

SQL> Select distinct Student.s_id
  2  from (Student join Takes using(s_id))
  3  join (Instructor join Teaches using(i_id))
  4  using (course_id, sec_id, semester, year)
  5  where instructor.name = 'evan';   

标签： sqloracle

Answer 1

删除对Student中的引用select：

select distinct s_id