load from 2 qvd

[amiroh81]

Hi

I Have 2 QVD,

I want to load the first one and in the where option to load fron the secound qvd,

what is the right syntax ?

thanks in advanced

Amir

[ashfaq_haseeb]

Hi,

Try something like below

Second:

Load

ID,

Filed1,

Field2,

.

.

FieldN

From Second.qvd;

First:

Load

ID,

Filed1,

Field2,

.

.

FieldN

From First.qvd Where Exists(ID,ID);

Regards

ASHFAQ

[renjithpl]

Hi Amir,

What you want to achieve, basically, this is how a very basic load from two QVD's look like..

pls provide more details if anything else required.. thanks

First_QVD:

LOAD Date,
ID,
Value
FROM
\\..\First.qvd
(qvd);
Second_QVD:
LOAD Name,
ID
FROM
\\..\Second.qvd
(qvd) where ID <> '54321';