Where match() clause with column of another table

[heid_f]

Hey all,

I'm working on an app right now and have following problem.

I got a first table of Employees and an employee_id.

Now I want to load all Calls (from an qvd - file) where the Call.employee exists in Employees.

I tried to use the match function, but I don't know how to refer to the employee_id column of another table.

Is this possible?

Thanks for your answers.

[micheledenardi · Accepted solution]

Try with Exists() function:

Employee:
Load
   employee_id,
   employee_id as employee_id_check,
   ...
From Employee.qvd(qvd);

Call:
Load
   ....
From Call.qvd(qvd)
 Where exists(employee_id_check,employee);
Drop field employee_id_check;