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

[johnlong]

Code: Select all

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

Would be incorrect?

[admin]

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.