Referencing fields from two different QVDs

[#1]

I have 2 QVDs

AMERICA:

Load

Salesperson

from America.qvd

CANADA:

Load

Product

from Canada.qvd

What I need to do is write an if statement ie

If (Salesperson like 'Smith' and Product like 'Steel*, 'Outsourced') as Outsourced_items

however as you can see my fields are coming from two different fields. Is there a simple way to do this ?

[aarkay29]

If there is a key linking the two qvd's then you can join them and use a If statement.