requirement

[Anonymous]

i have two qvds file,

with ids as common field,

so now I want to get the is which are in qvd1 and not in qvd2 and vice versa,

how to do that

[Anonymous]

For id which are in qvd1 but not in qvd2-

Load  qvd1 and

left join

load qvd2;

if I take a count of ids after loading above ,

it will give me the count of common ids in two table den I need to subtract it from total count?