Comment 0 for bug 652337

Revision history for this message
Timo Westkämper (timo-westkamper) wrote :

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());
        }