return doList();
}
public String doList()
{
SampleDB db = getDatabase();
SampleDB.Employees EMP = db.T_EMPLOYEES;
SampleDB.Departments DEP = db.T_DEPARTMENTS;
DBCommand cmd = db.createCommand();
cmd.select(EMP.C_EMPLOYEE_ID);
cmd.select(C_FULL_NAME, EMP.C_GENDER, EMP.C_DATE_OF_BIRTH);
cmd.select(C_DEPARTMENT);
cmd.join (DEP.C_DEPARTMENT_ID, EMP.C_DEPARTMENT_ID);