Enthuware

Posted: **Wed Dec 21, 2016 7:27 pm**

select c.instructor.name 
from Student s, Course c
where s.studentid = ?1

Would be incorrect?

Posted: **Thu Dec 22, 2016 11:59 pm**

The part "from Student s, Course c" will cause a cartesian product of Student with given student id and all courses. So this will not help. You need to join Student and Course to restrict the Courses.

HTH,
Paul.

Enthuware

About Question enthuware.oce-jpad.v6.2.487 :

About Question enthuware.oce-jpad.v6.2.487 :

Re: About Question enthuware.oce-jpad.v6.2.487 :