Page 1 of 1

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

Posted: Mon Jul 23, 2012 1:39 pm
by jszczepankiewicz
There is: LEFT JOIN FETCH

But this will return also students without presentations but in the instruction there is "Students WITH Presentations"
should it be? INNER JOIN FETCH?

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

Posted: Tue Jul 24, 2012 9:09 pm
by admin
The problem statement says, "...retrieve all students along with their associated presentations". This is very different from what you've written, "...retrieve all students with presentations".

LEFT JOIN is correct for the given statement.

HTH,
Paul.