各列定义不明 [英] Column Ambiguously Defined

问题描述

我得到了:

ORA-00918:列定义不明确 00918. 00000-列定义不明确"

ORA-00918: column ambiguously defined 00918. 00000 - "column ambiguously defined"

每当我尝试运行时:

select 
first_name as student_first_name, 
last_name as student_last_name

from super_student ss

inner join sub_distance_learning sdl
on sdl.student_id = ss.id

inner join sub_academic_tutor sat
on sat.id = sdl.academic_tutor_id

inner join super_sub_lecturer ssl
on ssl.id = sat.lecturer_id

inner join super_employee se
on se.id = ssl.employee_id;

仅在包含此错误时显示错误:

The error only shows when this is included:

inner join super_employee se
on se.id = ssl.employee_id;

有什么想法吗?

推荐答案

显然，一个以上的表中包含first_name和/或last_name，大概是super_student和super_employee.

Obviously, more than one table has first_name and/or last_name in it, presumably super_student and super_employee.

使用您很好定义的表别名:

Use the table aliases that you nicely defined:

select ss.first_name as student_first_name, 
       ss.last_name as student_last_name

这篇关于各列定义不明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！