concatenate the intersected data

[#1]

Hi,

I want to concatenate 2 qvds with intersected data.

I have 2 qvds. Both contain same field.

I want to load qvd2 with all data but load only intersected data from qvd1 . then i want to concatenate both qvds.

urget reply needed.

[deepakk]

HI rajni,

Use the Exists function or use inner join to make interaction between two qvds

eg:

Load * from A.

concatenate

Load

* from B where exists(PrimaryKey,PrimaryKey)

-----------------------------------------------------------------------

Load

* from A;

inner join

Load

* from B;