Help join QVD with join condition A.x<=B.x

[#1]

Hi,

I must do the join between 2 tables, A and B, with the join condition (A.x <= B.x) AND (A.y = B.y).

How I can do the condition (A.x <= B.x)?

MyVeryBigTable:

Load a1, a2, ...an, x, y

FROM A.qvd (qvd);

left join

Load b1, b2, ....bn, x, y

FROM B.qvd (qvd);

It's also very important the performance.

Thanks!

[#2]

Can you try this script.

I hope this can help you

MyVeryBigTable:

Load a1, a2, x, y

FROM A.qvd (qvd);

inner join

Load b1, b2, x as B.x , y

FROM B.qvd (qvd);

Final:
Load
*,
'' as Junk
Resident MyVeryBigTable where x<=B.x;

Drop Table MyVeryBigTable;
Drop Field Junk;