[discuss] Bug in relationship with inner join

[Antonio Parolini]

StudioDB 2.0.3

Hi,
I have writed 3 simple table with 2 relationship  (for example Student, Course, 
Teacher).

I Have write this query :

select  Student.IDM, Student.name, Student.secondname, Course.IDM, 
Course.Materia, Teacher.IDM, Teacher.namex
from Student 
inner join Course on Student.IDM = Course.IDM 
inner join Teacher on Teacher.IDM = Course.IDM;

the query run perfectly.


But if in table Teacher I change the name of attribute Teacher.namex to -----> 
Teacher.name 
and I rewrite the query :


select  Student.IDM, Student.name, Student.secondname, Course.IDM, 
Course.Materia, Teacher.IDM, Teacher.name
from Student 
inner join Course on Student.IDM = Course.IDM 
inner join Teacher on Teacher.IDM = Course.IDM

the query run (it not report sintax error), but the field Teacher.name value is 
equal to Student.name value. It is impossible.

Best Regards.
I migliori Saluti.