Provides by Luis Fernando Planella Gonzalez :
QPerson p = QPerson.person; QDepartment d = QDepartment.department; SQLQuery query =DB.from(p).innerJoin(p.departmentIdFk, d).orderBy(d.name.asc(), p.name.asc()); List<Beans> rows = query.list(new QBeans(p, d)); for (Beans beans : rows) { Person person = beans.get(p); Department department = beans.get(d); System.out.println(department.getName() + ", " + person.getName()); }
Provides by Luis Fernando Planella Gonzalez :
QPerson p = QPerson.person; department; p).innerJoin( p.departmentIdF k, d).orderBy( d.name. asc(), p.name.asc());
Department department = beans.get(d);
System. out.println( department. getName( ) + ", " + person.getName());
QDepartment d = QDepartment.
SQLQuery query =DB.from(
List<Beans> rows = query.list(new QBeans(p, d));
for (Beans beans : rows) {
Person person = beans.get(p);
}