DBStorage users = new DBStorage(); users.setQueryColumns(new String[] {"u.user_id", "u.user_name", "c.company_id", "c.company_name", "d.department_id", "d.department_name"}); users.setFromClause("users u, companies c, departments d"); users.setWhereClause("u.dep_id = d.id and d.comp_id = c.id"); users.setDefaultSort(new SortDefinition("company_name", "department_name", "user_name")); users.open();