How to compare the records of two similar QVD's and list out the missing records!

[#1]

Hi All

May I know which is the easiest way to compare the two similar QVD's and list out the missing records? For example I have two similar QVD's one is coming from Production and other is coming from Development. There are few records which are missing in the QVD which are coming from the Development.So I want to know which is the easiest way to find those records which are missing in the QVD which is coming from the Development when compared to the QVD coming from production.

Can someone please help me out in their convenient time!

Thanks and Regards,
Attitude

[#2]

Hi PariPari

I want something like below. Please let me know if you have any questions

Table-A;

X Y Z

1 2 3

4 5 6

7 8 9

12 13 14

Table-B:

X Y Z

1 2 3

4 5 6

7 8 10

16 17 18

Result which I need is:

Table-A - Table-B

X Y Z

7 8 9

12 13 14

Table-B - Table-A

X Y Z

7 8 10

16 17 18

[#3]

I did my best, try to look for help by somebody else:(

[#4]

Hi PariPari

Its ok! No issue!  Thanks for all your help. If you get some help anywhere please let me know.

Thanks,

Attitude