how to limit the number of result rows in an sql select

[#1]

Hello,

I run an ODBC query on a Progress database where we have Employees (table WERK) and Departments (table WAFD, linked by intersection table WEAF). I want to obtain only one result row for each employee with the most recent department they have worked in, but i get multiple rows: one for each department an employee has worked in the past. How can i limit the number of result rows per employee to just one?

SQL SELECT "WERK-nummer", "WERK-login" , "WERK-datum" FROM ERBS.PUB.WERK;
LEFT JOIN (WERK) SQL SELECT "WERK-nummer", "WAFD-nummer", "WEAF-vanaf" FROM ERBS.PUB.WEAF;

There does not seem to be a LIMIT keyword in Qlikview SQL. I would really appreciate if someone could help me in this. Thank you in advance!