Loading only rows when a condition exists in another table

[#1]

How would I go about loading the rows of a table when x condition is present in another table?

For example, if I have an telephone number spreadsheet with a key column with 1000 items (numbered 1-1000).  In another spreadsheet that only contains numbers I have actually called, I have the the same key column, but only certain numbers are populated (ie:  500, 501, 515, 516, 523, etc...).   When creating my qlikview table, I only want to load the telephone in the qlikview telephone table when it exists in the table of numbers that I actually called.

[#2]

You can use where exists functionality of QlikView

[Gysbert_Wassenaar]

Something like this:

Calls:

Load telnum, ...other fields... from ...mycallstable...;

Phonebook:

Load telnum, ...other fields... from ...myphonebook...

where exists(telnum, telnum);

[#4]

Thanks... actually my field names in each table are different.  When I try with both field names, I get an error in the calls table that "telnumcalls" does not exist.

[#5]

You can use following code as example else pl upload your Qvw.

History:
Load Order_No,

Price_Value
from Sales.qvd(Qvd)

;

Load Order_No,

Sale_Value

from Order.qvd(Qvd)

where exists(Order_No, Order_No)
;