hi,
i want to know whether it is possible to write JPQL query, involving outer join on entity beans without association??
e.g. 2 entity beans:
class Employee
{
@Id
String name;
String projectID;
String phone;
....
....
}
class Project
{
@Id
String projectID;
String description;
....
....
}
***each employee can involed in zero or one project
***project can have zero or more employee joined.
the 2 entity beans above don't have any association defined.
what i want to is to write a query to get a list of employee and, if exists,
the project employee involved in.
select e.name, p
from Employee e left join Project p on (e.projectID = p.projectID)
>>i search the document / tutorials that all left join examples involve
>>association.
>>e.g. select xx from XX left join XX.yy
could anybody tell me the answer?
thank you
[Message sent by forum member 'imperfect' (imperfect)]
http://forums.java.net/jive/thread.jspa?messageID=208868