concatenation and where not exists difficulty

[#1]

Hi,

I would like to join some records onto a table from another table where the composit key does not exist but I am unsure of the syntax.  Should it be as follows?

fact:

load *,

a&b as Key

from qvd;

concatenate (fact)

load *,

a&b as Key

where not exists(a&b);

Will this give me the required results?  Any help would be much appreciated.

Thanks.

[v_iyyappan]

Hi,

     Using left Join function using in your script instead of concatnate

     fact:

     load *,

     a&b as Key

     from qvd;

     left join(fact)

     load *,

     a&b as Key

     where not exists(a&b);

Regards,

Iyyappan

[CELAMBARASAN]

Hi,

     I'm not sure how you need to join the tables.

Using concatenate if you all the fields are in common in both tables.

fact:

load *,

a&b as Key

from qvd;

concatenate (fact)

load *;

where not exists(Key);

Load

     *,

     a&b as Key

From Qvd2;

Or You want to join

fact:

load *,

a&b as Key

from qvd;

Left Join (fact)

load *;

where not exists(Key);

Load

     *,

     a&b as Key

From Qvd2;

Celambarasan