Joining two qvds using inner join

[Vinni2000]

I want join two qvds using inner joining so I have two common fields between two tables those are order_number and item_number

[MayilVahanan · Accepted solution]

Hi

Just do the inner join, it will reflect based on both fields.

Load * from QVD1.qvd(qvd);
Inner join
Load * from QVD2.qvd(qvd);

Suppose if you want to do based on one field alone, then rename one of the field.