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

Moderator: admin

Post Reply
jszczepankiewicz

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

Post 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?

admin
Site Admin
Posts: 10065
Joined: Fri Sep 10, 2010 9:26 pm
Contact:

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

Post 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.
If you like our products and services, please help us by posting your review here.

Post Reply

Who is online

Users browsing this forum: No registered users and 62 guests