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?
About Question enthuware.oce-jpad.v6.2.529 :
Moderator: admin
-
- Site Admin
- Posts: 10386
- Joined: Fri Sep 10, 2010 9:26 pm
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.529 :
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.
LEFT JOIN is correct for the given statement.
HTH,
Paul.
Who is online
Users browsing this forum: No registered users and 4 guests