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: 10065
- 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.
If you like our products and services, please help us by posting your review here.
Who is online
Users browsing this forum: No registered users and 62 guests