Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?