How to write JDOQL Query to get data from multiple objects(Relational Objects)

173 Views Asked by At

I want to write a JDOQL query(JDOQL Delarative or JDOQL Single String ). Here are my classes

public class Customer
{
String Cid;
String Name;
String Email;
String City;
Set<Address> addresses=new HashSet<Address>();
}
public class Address 
{

String Aid;
String City; 
String Location;
}

1-N RelaitonShip between Customer and Address objects.

here's my database query

select c.Name,c.Email,a.City,a.Location from user.MASCUSTOMER c inner join user.MASADDRESS a on c.Cid= a.Cid;

How can i represent above query in the form of JDOQL (Delcarative or Single String)?

0

There are 0 best solutions below